Table: ScheduleJob

The scheduler of Scout Enterprise uses this table to store and manage all planned jobs.

ColumnName DataType Key Not Null   Default Value Comment
ScheduleJobID INTEGER PK NN   Unique ID of scheduled job
Type INTEGER       Job type
1SCD_TYPE_DEVICE ID refers to Device
2 SCD_TYPE_GROUP ID refers to Groups
Id INTEGER (FK)     ID of scheduled entity
Depends on Type
Refers to table Groups or Device
Addr1 NVARCHAR(255)       Address of entity 
Addr2 NVARCHAR(255)        
Occur INTEGER        
Days NVARCHAR(255)        
ScheduleHour INTEGER        
ScheduleMin INTEGER        
ScheduleTime INTEGER        
Cmd NVARCHAR(255)        
sParam NVARCHAR(max)        
iParam INTEGER        
ScheduleOption INTEGER        
TimeCreated INTEGER   NN   Creation time (Unix time)
TimeModified INTEGER   NN   Last modification (Unix time)
TimeDone INTEGER   NN   Time of completion (Unix time)
Status INTEGER       Not used
SleepAfterSend INTEGER       Time period in ms to go to sleep mode after sending commands to devices. This is useful when commands are sent to many devices
Administrator NVARCHAR(255)       Administrator who has scheduled the job
Result INTEGER       Not used
ReservedString1 NVARCHAR(255)        
ReservedString2 NVARCHAR(255)        
ReservedInt1 INTEGER        
ReservedInt2 INTEGER        
MessageTitle NVARCHAR(255)       Message title for SEND MESSAGE commands
RootOU INTEGER       Required to check if the scheduled jobs are within the admin's OU hierarchy
FriendlyName NVARCHAR(255)       Friendly name for command
IndexName IndexType Columns
PRIMARY PRIMARY ScheduleJobID

 

How to create

CREATE TABLE ScheduleJob(
ScheduleJobID INTEGER NOT NULL,
Type INTEGER,
Id INTEGER,
Addr1 NVARCHAR(255),
Addr2 NVARCHAR(255),
Occur INTEGER,
Days NVARCHAR(255),
ScheduleHour INTEGER,
ScheduleMin INTEGER,
ScheduleTime INTEGER,
Cmd NVARCHAR(255),
sParam NVARCHAR(max),
iParam INTEGER,
ScheduleOption INTEGER,
TimeCreated INTEGER NOT NULL,
TimeModified INTEGER NOT NULL,
TimeDone INTEGER NOT NULL,
Status INTEGER,
Result INTEGER,
SleepAfterSend INTEGER,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
MessageTitle NVARCHAR(255),
RootOU INTEGER,
FriendlyName NVARCHAR(255),
PRIMARY KEY (ScheduleJobID));