Release 3.00
Mar 03, 2005
|
Sybernet / Supplied Procedures Reference
Release 3.00 Mar 03, 2005 |
|
This application program allows you to monitor tasks (stored procedures and UNIX processes) with your web browser. By default, the monitor attempts to list the last 3 COMPLETED entries, all active entries and any SCHEDULED entries.
If you have the proper permissions, you can also control SCHEDULED and RUNNING tasks with the Sybercron Monitor; for example, you might be able to kill a RUNNING stored procedure or change the execution date of a SCHEDULED task. Sometimes this works, sometimes not. While stored procedures can be killed, UNIX processes can't. If a process has moved from SCHEDULED to QUEUED or WAITING, you can no longer change its execution date.
| Column | Description |
|---|---|
status |
This column indicates the current status of your stored procedure. COMPLETED
means your procedure COMPLETED successfully with a non-negative return result.
SUSPECT means your stored procedure COMPLETED unsuccessfully or terminated with
a negative return result. RUNNING means your stored procedure is now executing.
WAITING means Sybercron is about to fork another process to execute your stored
procedure. QUEUED means your stored procedure is WAITING for Sybercron to run it.
SCHEDULED means your stored procedure is SCHEDULED to be executed sometime in
the future.
SCHEDULED entries can be changed to QUEUED. This will change the timestamp to the current system date making this procedure available for immediate execution. SCHEDULED and QUEUED entries can be changed to KILL. This will cause the entry to be deleted from the CRON table. It will have to be reregistered. You may find it more useful to change the timestamp to a value sometime in the future. RUNNING entries can be changed to KILL. If you have the appropriate role, this will cause this process to be terminated. |
procname |
The name of your stored procedure. For RUNNING entries, the current command name (from sysprocesses) is appended to this name. |
title |
The title that you have specified. For E-mail, TITLE is also the subject of your mail. |
platform |
The name of the PLATFORM that Syberron is to run from. Platform names are defined in the table CRON_PLATFORMS. |
result |
The return result of your stored procedure. WAITING and RUNNING procedures will have a value of NULL (since they haven't returned). SCHEDULED and QUEUED entries will be blank in this field. |
date |
For QUEUED and SCHEDULED entries, this is the TIMESTAMP that it will be executed.
For WAITING and RUNNING entries, this is the TIMESTAMP when it started.
For COMPLETED and SUSPECT entries, this is the TIMESTAMP when it finished.
You can change the DATE field on any SCHEDULED or QUEUED entry. This is a convenient way to change its execution date without actually deleting it from the CRON table. |
cpu |
This field contains the total CPU time in ticks for COMPLETED and SUSPECT entries or the total accumulated CPU time in ticks for RUNNING entries. The field is blank for QUEUED and SCHEDULED entries. |
time |
For COMPLETED and SUSPECT entries this column represents the elapsed time of your stored procedure. For RUNNING and WAITING entries it represents the amount of time it has been RUNNING. For QUEUED entries, it represents the amount of time (as a negative value) that this procedure has been WAITING to run. And for SCHEDULED entries it represents the amount time left before this procedure is selected for execution. |
Click Preferences to specify rows, border, cellPadding and cellSpacing.
Only the last 30 days of COMPLETED entries are displayed. This may be unacceptable,
but the purpose was to speed up the display since CRON_HISTORY can contain
thousands of rows and there is no index on this table.
| Button | Description |
|---|---|
Backward |
Scrolls the window backwards one screen. |
Refresh |
Go to and refresh the current active window. |
Forward |
Scrolls the window forwards one screen. |