Schedule Table

The Schedule Table (Schedule_tb) contains a record for every event in the Sterling Gentran:Server® system.

The translator creates a record when you create an event in process control. The translator updates a record when you modify an event. The translator deletes a record when you delete an event from the system.

Table 1. Schedule Table field information
Field Name Type Size Use
Time string 50 Time the event is run (for timed events only).
SessionFile string 50 Name of the session that is run.
Calendar string 50 Name of the calendar used to determine when the event should be run (timed events only).
Parm1 string 128 User-defined parameter.
Parm2 string 128 User-defined parameter.
Parm3 string 128 User-defined parameter.
Owner string 50 Reserved for future use.
OwnerDomain string 50 Reserved for future use.
EventType number (integer) 2 Indicates whether the event is polled:
  • 0 = Scheduled
  • 1 = Polled
  • 2 = Notify
  • 3 = System
ProcessID number (long) 4 Identifier of the process that is running the session specified in the event:
  • 0 = process is not running
  • non-zero = process is running
TimeStarted number (long) 4 Time the event started.
TimeEnded number (long) 4 Time the event ended.
ServerName string 50 Name of the controller on which the event is run.
CurrentSessionCmd Nbr number (long) 4 Name of the event that is currently processing.
Event string 50 Description of the event.
Status number (integer) 2 Indicates whether the event is suspended or active:
  • 0 = suspended
  • 1 = activated
  • 2 = blocked
  • 3 = execute
EventID string 10 Unique event identifier.