Schedules Table
STEPforward can schedule automatic execution of Reports and Processes. The schedules are created by the Report or Process editor, and also by the Report or Process Runner applications. The schedules are stored in table SF_SYSSchedule of the following structure (here "process" is denotes both reports and processes):
Column | Generalized data type | Use |
JobName | VARCHAR(255) | Name of the scheduled process |
Parameters | BLOB | Archived NSArray of SFVariable objects |
VisualParameters | BLOB | Archived NSArray of SFVisualParameter objects |
Type | TINYINT | Type of the report (REPORT or PROCESS) |
Host | VARCHAR(255) | Host that runs the process |
Frequency | TINYINT | Frequency code for submission of process |
Day | TINYINT | Day of submission of the process |
Hour | TINYINT | Hour of submission of the process |
Minute | TINYINT | Minute of submission of the process |
Owner | VARCHAR(255) | Run-time owner (login account) of the process |
LastRunDate | CHAR(8) | Last date of execution of scheduled process |
LastRunTime | CHAR(6) | Last time of execution of scheduled process |
SF_UserId | VARCHAR(255) | User-id of the user that last updated the schedule |
SF_DateChanged | CHAR(8) | Date of the last update of the row (CCYYMMDD) |
SF_TimeChanged | CHAR(6) | Time of the last update of the row (HHMMSS) |
SF_TimeStamp | SMALLINT | Version of the row (incremented with each update) |
Notes:
The table contains one row for each scheduled process. The table is read by STEPforward Server and cached in its volatile memory throughout the Server's life.
Parameters is an archived NSArray that stores SFVariable objects. These objects are passed to the process at the run time as parameters.
VisualParameters is an archived NSArray that stores SFVisualParameter objects. These objects are used by the Schedule editor to display current settings of parameters that are passed to the process.
Type is a code that tracks the type of scheduled process. Report schedules have type 0; process schedules' type is 1.
Host is the name of host on which the process will be run.
Frequency code determines how often the process will be submitted. The following frequency codes are used by STEPforward:
0 | Once per month | |
1 | Once per week | |
2 | Every day | |
3 | Every hour | |
4 | Every minute |
Day is the number of day on which to schedule the process for monthly schedules, or day of week for weekly schedules. If weekly frequency is used, Day code is set as follows:
0 | Sunday | |
1 | Monday | |
2 | Tuesday | |
3 | Wednesday | |
4 | Thursday | |
5 | Friday | |
6 | Saturday |
Hour is the hour of day (in 24-hour format) when the process is to be run. Hour value is set only for monthly, weekly and daily schedules.
Minute is the minute of hour when the process is to be run. Minute value is set only for monthly, weekly daily and hourly schedules. For schedules of "Minute" frequency this value is interpreted as the interval between submissions in minutes.
Owner is the login account that the process will used during its run time. Data access rights are determined on the basis of the Owner, regardless of the actual login account that executes the process.
LastRunDate and LastRunTime are date and time of the last submission of the scheduled process.