pears.IQXJobRunnerSchedule

Details of individual Jobs and their scheduled run times within a Schedule Group

• ScheduleID

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXJobRunnerSchedule"
-- Table comment: Details of individual Jobs and their scheduled run times within a Schedule Group
-- Statement count: 11
 
CREATE TABLE "pears"."IQXJobRunnerSchedule" (
    "ScheduleID"                     CHAR(20) NOT NULL
   ,"GroupID"                        CHAR(20) NOT NULL
   ,"Sequence"                       INTEGER NULL
   ,"Active"                         SMALLINT NULL
   ,"Mon"                            SMALLINT NULL
   ,"Tue"                            SMALLINT NULL
   ,"Wed"                            SMALLINT NULL
   ,"Thu"                            SMALLINT NULL
   ,"Fri"                            SMALLINT NULL
   ,"Sat"                            SMALLINT NULL
   ,"Sun"                            SMALLINT NULL
   ,"DayOfMonth"                     SMALLINT NULL
   ,"Repetition"                     SMALLINT NULL DEFAULT 0
   ,"RepetitionInterval"             SMALLINT NULL DEFAULT 0
   ,"StartTime"                      TIME NULL
   ,"StopTime"                       TIME NULL
   ,"JobFile"                        CHAR(250) NULL
   ,"Comments"                       long VARCHAR NULL
   ,"LastRun"                        TIMESTAMP NULL
   ,"Parameters"                     long VARCHAR NULL
   ,"RunNow"                         SMALLINT NULL DEFAULT 0
   ,PRIMARY KEY ("ScheduleID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQXJobRunnerSchedule"."DayOfMonth" IS 
	'Alternative to specifying weekdays'
GO
 
 
COMMENT ON COLUMN "pears"."IQXJobRunnerSchedule"."Repetition" IS 
	'0=Once per day 1=Seconds 60=Minutes 3600=Hours'
GO
 
 
COMMENT ON COLUMN "pears"."IQXJobRunnerSchedule"."RepetitionInterval" IS 
	'If Repetition<>0. 0 is effectively continuous.'
GO
 
 
COMMENT ON COLUMN "pears"."IQXJobRunnerSchedule"."StartTime" IS 
	'Null means start at beginning of day'
GO
 
 
COMMENT ON COLUMN "pears"."IQXJobRunnerSchedule"."StopTime" IS 
	'Null means stop at end of day'
GO
 
 
COMMENT ON COLUMN "pears"."IQXJobRunnerSchedule"."LastRun" IS 
	'Updated when the job is run'
GO
 
 
COMMENT ON COLUMN "pears"."IQXJobRunnerSchedule"."RunNow" IS 
	'One-off instruction to run immediately then zero the field'
GO
 
 
COMMENT ON TABLE "pears"."IQXJobRunnerSchedule" IS 
	'Details of individual Jobs and their scheduled run times within a Schedule Group'
GO
 
 
ALTER TABLE "pears"."IQXJobRunnerSchedule"
    ADD NOT NULL FOREIGN KEY "IQXJobRunnerScheduleGroup" ("GroupID" ASC)
    REFERENCES "pears"."IQXJobRunnerScheduleGroup" ("GroupID")
GO
 
 
CREATE INDEX "IQXJRSequence" ON "pears"."IQXJobRunnerSchedule"
    ( "Sequence" )
GO