Table of Contents



pears.IQXJobRunnerLog

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

Log of sucessful and failed runs by the Scheduler

Columns

Column Type Null Default Comment
LogID char(20) NOT NULL
ScheduleID char(20) NOT NULL
StartTime timestamp NOT NULL
CompletionTime timestamp NULL
MachineName char(100) NULL
Status integer NULL
ErrorMessage long varchar NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
IQXJobRunnerSchedule ScheduleID pears.IQXJobRunnerSchedule (ScheduleID) NOT NULL; ON DELETE CASCADE

Referenced By

Indexes

Name Type Columns Detail
IQXJRJobStart Index ScheduleID, StartTime
IQXJRStart Index StartTime

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXJobRunnerLog"
-- Table comment: Log of sucessful and failed runs by the Scheduler
-- Statement count: 5
 
CREATE TABLE "pears"."IQXJobRunnerLog" (
    "LogID"                          CHAR(20) NOT NULL
   ,"ScheduleID"                     CHAR(20) NOT NULL
   ,"StartTime"                      TIMESTAMP NOT NULL
   ,"CompletionTime"                 TIMESTAMP NULL
   ,"MachineName"                    CHAR(100) NULL
   ,"Status"                         INTEGER NULL
   ,"ErrorMessage"                   long VARCHAR NULL
   ,PRIMARY KEY ("LogID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."IQXJobRunnerLog" IS 
	'Log of sucessful and failed runs by the Scheduler'
GO
 
 
ALTER TABLE "pears"."IQXJobRunnerLog"
    ADD NOT NULL FOREIGN KEY "IQXJobRunnerSchedule" ("ScheduleID" ASC)
    REFERENCES "pears"."IQXJobRunnerSchedule" ("ScheduleID")
    ON DELETE CASCADE
GO
 
 
CREATE INDEX "IQXJRJobStart" ON "pears"."IQXJobRunnerLog"
    ( "ScheduleID","StartTime" )
GO
 
 
CREATE INDEX "IQXJRStart" ON "pears"."IQXJobRunnerLog"
    ( "StartTime" )
GO