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.