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 |
SF_JobName | VARCHAR(255) | Name of the scheduled process |
SF_Parameters | BLOB | Archived NSArray of SFVariable objects |
SF_VisualParameters | BLOB | Archived NSArray of SFVisualParameter objects |
SF_Type | TINYINT | Type of the report (REPORT or PROCESS) |
SF_Host | VARCHAR(255) | Host that runs the process |
SF_Frequency | TINYINT | Frequency code for submission of process |
SF_Day | TINYINT | Day of submission of the process |
SF_Hour | TINYINT | Hour of submission of the process |
SF_Minute | TINYINT | Minute of submission of the process |
SF_Owner | VARCHAR(255) | Run-time owner (login account) of the process |
SF_LastRunDate | CHAR(8) | Last date of execution of scheduled process |
SF_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.
SF_Parameters is an archived NSArray that stores SFVariable objects. These objects are passed to the process at the run time as parameters.
SF_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.
SF_Type is a code that tracks the type of scheduled process. Report schedules have type 0; process schedules' type is 1.
SF_Host is the name of host on which the process will be run.
SF_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 |
SF_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, SF_Day code is set as follows:
0 | Sunday | |
1 | Monday | |
2 | Tuesday | |
3 | Wednesday | |
4 | Thursday | |
5 | Friday | |
6 | Saturday |
SF_Hour is the hour of day (in 24-hour format) when the process is to be run. SF_Hour value is set only for monthly, weekly and daily schedules.
SF_Minute is the minute of hour when the process is to be run. SF_Minute value is set only for monthly, weekly daily and hourly schedules. For schedules of "SF_Minute" frequency this value is interpreted as the interval between submissions in minutes.
SF_Owner is the login account that the process will used during its run time. Data access rights are determined on the basis of the SF_Owner, regardless of the actual login account that executes the process.
SF_LastRunDate and SF_LastRunTime are date and time of the last submission of the scheduled process.