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:



Related DDL Statements

---