Icon Jobs Table

Structure
CREATE TABLE "Jobs"
(
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Attributes" CLOB COLLATE "ANSI",
"Version" DECIMAL(19,2),
"Category" VARCHAR(15) COLLATE "ANSI_CI",
"UserName" VARCHAR(40) COLLATE "ANSI_CI",
"StartDate" DATE,
"EndDate" DATE,
"Type" VARCHAR(15) COLLATE "ANSI_CI",
"Interval" INTEGER,
"Days" VARCHAR(60) COLLATE "ANSI_CI",
"DayNumber" INTEGER,
"DayOfMonth" VARCHAR(15) COLLATE "ANSI_CI",
"Months" VARCHAR(60) COLLATE "ANSI_CI",
"StartTime" TIME,
"EndTime" TIME,
"Definition" CLOB COLLATE "ANSI",
"Enabled" BOOLEAN,
"LastRun" TIMESTAMP,
"NextRun" TIMESTAMP,
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "Name" ON "Jobs"
("Name")

Description
This table contains the defined jobs in an ElevateDB configuration. Jobs are stored procedures that don't accept or output any parameters and are not contained within a specific database. Jobs are scheduled when they are defined and can only be executed by an ElevateDB server. In addition, each job can be assigned a category so that it is run on a specific ElevateDB server that is serving a particular category of jobs.

The Type column values are as follows:

TypeDescription
OnceThe job is scheduled to execute only once
HourlyThe job is scheduled to execute every hour
DailyThe job is scheduled to execute every day
WeeklyThe job is scheduled to execute every week
MonthlyThe job is scheduled to execute every month
Every X MinutesThe job is scheduled to execute every X number of minutes
Every X HoursThe job is scheduled to execute every X number of hours
Every X DaysThe job is scheduled to execute every X number of days
Every X WeeksThe job is scheduled to execute every X number of weeks
At Server StartThe job is scheduled to execute when the ElevateDB Server is started

Information The NextRun column will be NULL for any jobs that are disabled.

Related DDL Statements
StatementDescription
CREATE JOBCreates a new job
ALTER JOBAlters an existing job
DROP JOBDrops an existing job
RENAME JOBRenames an existing job
ENABLE JOBEnables an existing job
DISABLE JOBDisables an existing job
ENABLE JOBSEnables all existing jobs
DISABLE JOBSDisables all existing jobs
Image