ADD TABLE "SmartSchedulerJob"
  AREA "Data"
  LABEL "Scheduler Job"
  LABEL-SA "U"
  VALMSG-SA "U"
  DUMP-NAME "smartschedulerjob"
  TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "SmartDBtrgs/crSSchedulerJob.p" CRC "?" 

ADD FIELD "SchedulerJobGuid" OF "SmartSchedulerJob" AS character 
  FORMAT "x(36)"
  INITIAL ""
  LABEL "Job Guid"
  POSITION 2
  MAX-WIDTH 72
  COLUMN-LABEL "Job Guid"
  ORDER 10

ADD FIELD "SchedulerJobName" OF "SmartSchedulerJob" AS character 
  FORMAT "x(40)"
  INITIAL ""
  LABEL "JobName"
  POSITION 3
  MAX-WIDTH 80
  COLUMN-LABEL "JobName"
  ORDER 20

ADD FIELD "Description" OF "SmartSchedulerJob" AS character 
  FORMAT "x(400)"
  INITIAL ""
  LABEL "Description"
  POSITION 4
  MAX-WIDTH 800
  COLUMN-LABEL "Job Description"
  ORDER 30

ADD FIELD "MaxRuntime" OF "SmartSchedulerJob" AS integer 
  DESCRIPTION "Maximum runtime of the Job in seconds. 0 for no runtime limit."
  FORMAT "zzzz9"
  INITIAL "0"
  LABEL "MaxRuntime"
  POSITION 5
  MAX-WIDTH 4
  COLUMN-LABEL "MaxRuntime"
  ORDER 40

ADD FIELD "JobCommand" OF "SmartSchedulerJob" AS clob 
  DESCRIPTION "The XML or JSON Serialized ISchedulerJobCommand instance"
  FORMAT "x(8)"
  INITIAL ?
  POSITION 6
  LOB-AREA "LOB"
  LOB-BYTES 104857600
  LOB-SIZE 100M
  CLOB-CODEPAGE "UTF-8"
  CLOB-COLLATION "basic"
  CLOB-TYPE 2
  ORDER 50

ADD INDEX "Job" ON "SmartSchedulerJob" 
  AREA "Index"
  UNIQUE
  PRIMARY
  INDEX-FIELD "SchedulerJobGuid" ASCENDING 

ADD INDEX "JobName" ON "SmartSchedulerJob" 
  AREA "Index"
  INDEX-FIELD "SchedulerJobName" ASCENDING 

ADD TABLE "SmartSchedulerJobPlan"
  AREA "Data"
  LABEL "Scheduler JobPlan"
  LABEL-SA "U"
  VALMSG-SA "U"
  DUMP-NAME "smartschedulerjobplan"
  TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "SmartDBtrgs/crSSchedulerJobPlan.p" CRC "?" 

ADD FIELD "SchedulerJobPlanGuid" OF "SmartSchedulerJobPlan" AS character 
  FORMAT "x(36)"
  INITIAL ""
  LABEL "Job Status ID"
  POSITION 2
  MAX-WIDTH 72
  COLUMN-LABEL "Job Status ID"
  ORDER 10

ADD FIELD "SchedulerJobGuid" OF "SmartSchedulerJobPlan" AS character 
  FORMAT "x(36)"
  INITIAL ""
  LABEL "Job Guid"
  POSITION 3
  MAX-WIDTH 72
  COLUMN-LABEL "Job Guid"
  ORDER 20

ADD FIELD "MaxRuntime" OF "SmartSchedulerJobPlan" AS integer 
  DESCRIPTION "Maximum runtime of the Job in seconds. 0 for no runtime limit."
  FORMAT "zzzz9"
  INITIAL "0"
  LABEL "MaxRuntime"
  POSITION 4
  MAX-WIDTH 4
  COLUMN-LABEL "MaxRuntime"
  ORDER 30

ADD FIELD "MaxExecutionDelay" OF "SmartSchedulerJobPlan" AS integer 
  DESCRIPTION "Maximum delay (in seconds) in which the job can be started after the scheduled time."
  FORMAT "zzzz9"
  INITIAL "0"
  LABEL "Max. Delay"
  POSITION 5
  MAX-WIDTH 4
  COLUMN-LABEL "Max. Delay"
  ORDER 40

ADD FIELD "JobParamter" OF "SmartSchedulerJobPlan" AS clob 
  DESCRIPTION "XML/JSON Serialized parameter  instance "
  FORMAT "x(8)"
  INITIAL ?
  POSITION 6
  LOB-AREA "LOB"
  LOB-BYTES 104857600
  LOB-SIZE 100M
  CLOB-CODEPAGE "UTF-8"
  CLOB-COLLATION "basic"
  CLOB-TYPE 2
  ORDER 50

ADD FIELD "PlanningType" OF "SmartSchedulerJobPlan" AS character 
  DESCRIPTION "Once/Weekly/Monthly"
  FORMAT "x(15)"
  INITIAL ""
  LABEL "Plan Type"
  POSITION 7
  MAX-WIDTH 30
  COLUMN-LABEL "Plan Type"
  ORDER 60

ADD FIELD "ScheduleDateTime" OF "SmartSchedulerJobPlan" AS datetime-tz 
  DESCRIPTION "Once Now/Scheduled"
  FORMAT "99/99/9999 HH:MM:SS.SSS+HH:MM"
  INITIAL ?
  LABEL "Once Now/Scheduled"
  POSITION 8
  MAX-WIDTH 12
  COLUMN-LABEL "Once Now/Scheduled"
  ORDER 70

ADD FIELD "RecurringMonday" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring Monday"
  POSITION 9
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring Monday"
  ORDER 80

ADD FIELD "RecurringTuesday" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring Tuesday"
  POSITION 10
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring Tuesday"
  ORDER 90

ADD FIELD "RecurringWednesday" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring Wendesday"
  POSITION 11
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring Wendesday"
  ORDER 100

ADD FIELD "RecurringThursday" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring Thursday"
  POSITION 12
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring Thursday"
  ORDER 110

ADD FIELD "RecurringFriday" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring Friday"
  POSITION 13
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring Friday"
  ORDER 120

ADD FIELD "RecurringSaturday" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring Saturday"
  POSITION 14
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring Saturday"
  ORDER 130

ADD FIELD "RecurringSunday" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring Sunday"
  POSITION 15
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring Sunday"
  ORDER 140

ADD FIELD "WeekInterval" OF "SmartSchedulerJobPlan" AS integer 
  FORMAT "z9"
  INITIAL "0"
  LABEL "Week Interval"
  POSITION 16
  MAX-WIDTH 4
  COLUMN-LABEL "Week Interval"
  ORDER 150

ADD FIELD "RecurringJanuary" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring January"
  POSITION 17
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring January"
  ORDER 160

ADD FIELD "RecurringFebruary" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring February"
  POSITION 18
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring February"
  ORDER 170

ADD FIELD "RecurringMarch" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring March"
  POSITION 19
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring March"
  ORDER 180

ADD FIELD "RecurringApril" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring April"
  POSITION 20
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring April"
  ORDER 190

ADD FIELD "RecurringMay" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring May"
  POSITION 21
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring May"
  ORDER 200

ADD FIELD "RecurringJune" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring June"
  POSITION 22
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring June"
  ORDER 210

ADD FIELD "RecurringJuly" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring July"
  POSITION 23
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring July"
  ORDER 220

ADD FIELD "RecurringAugust" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring August"
  POSITION 24
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring August"
  ORDER 230

ADD FIELD "RecurringSeptember" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring September"
  POSITION 25
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring September"
  ORDER 240

ADD FIELD "RecurringOctober" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring October"
  POSITION 26
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring October"
  ORDER 250

ADD FIELD "RecurringNovember" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring November"
  POSITION 27
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring November"
  ORDER 260

ADD FIELD "RecurringDecember" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring December"
  POSITION 28
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring December"
  ORDER 270

ADD FIELD "RecurringDaylist" OF "SmartSchedulerJobPlan" AS character 
  DESCRIPTION "List of days e.g. 1,7,17,-5"
  FORMAT "x(30)"
  INITIAL ""
  LABEL "Recurring Daylist"
  POSITION 29
  MAX-WIDTH 60
  COLUMN-LABEL "Recurring Daylist"
  ORDER 280

ADD FIELD "RecurringExecutionTimes" OF "SmartSchedulerJobPlan" AS character 
  DESCRIPTION "List of execution times, e.g. 02:00,17:14:16,18:00"
  FORMAT "x(30)"
  INITIAL ""
  LABEL "Recurring Execution Times"
  POSITION 30
  MAX-WIDTH 60
  COLUMN-LABEL "Recurring Execution Times"
  ORDER 290

ADD FIELD "ValidFrom" OF "SmartSchedulerJobPlan" AS datetime-tz 
  DESCRIPTION "(optional)"
  FORMAT "99/99/9999 HH:MM:SS.SSS+HH:MM"
  INITIAL ?
  LABEL "JobPlan valid from"
  POSITION 31
  MAX-WIDTH 12
  COLUMN-LABEL "JobPlan valid from"
  ORDER 300

ADD FIELD "ValidTo" OF "SmartSchedulerJobPlan" AS datetime-tz 
  DESCRIPTION "(optional)"
  FORMAT "99/99/9999 HH:MM:SS.SSS+HH:MM"
  INITIAL ?
  LABEL "JobPlan valid to"
  POSITION 32
  MAX-WIDTH 12
  COLUMN-LABEL "JobPlan valid to"
  ORDER 310

ADD FIELD "Active" OF "SmartSchedulerJobPlan" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "JobPlan is active"
  POSITION 33
  MAX-WIDTH 1
  COLUMN-LABEL "JobPlan is active"
  ORDER 320

ADD FIELD "ContextDataSet" OF "SmartSchedulerJobPlan" AS clob 
  DESCRIPTION "optionally Inherit context-dataset from the session that planned this job"
  FORMAT "x(8)"
  INITIAL ?
  POSITION 34
  LOB-AREA "LOB"
  LOB-BYTES 104857600
  LOB-SIZE 100M
  CLOB-CODEPAGE "UTF-8"
  CLOB-COLLATION "basic"
  CLOB-TYPE 0
  ORDER 330

ADD FIELD "UserGuid" OF "SmartSchedulerJobPlan" AS character 
  FORMAT "x(36)"
  INITIAL ""
  LABEL "UserGuid"
  POSITION 35
  MAX-WIDTH 72
  COLUMN-LABEL "UserGuid"
  ORDER 340

ADD FIELD "DataBaseConnections" OF "SmartSchedulerJobPlan" AS character 
  DESCRIPTION "Database connections (when not already conneced by scheduler agent)"
  FORMAT "x(120)"
  INITIAL ""
  LABEL "DataBaseConnections"
  POSITION 36
  MAX-WIDTH 240
  COLUMN-LABEL "DataBaseConnections"
  ORDER 350

ADD FIELD "ClientPrincipal" OF "SmartSchedulerJobPlan" AS raw 
  FORMAT "x(80)"
  INITIAL ""
  POSITION 37
  MAX-WIDTH 160
  ORDER 360

ADD INDEX "JobPlan" ON "SmartSchedulerJobPlan" 
  AREA "Index"
  UNIQUE
  PRIMARY
  INDEX-FIELD "SchedulerJobPlanGuid" ASCENDING 

ADD INDEX "Job" ON "SmartSchedulerJobPlan" 
  AREA "Index"
  INDEX-FIELD "SchedulerJobGuid" ASCENDING 

ADD TABLE "SmartSchedulerJobStatus"
  AREA "Data"
  LABEL "Scheduler JobStatus"
  LABEL-SA "U"
  VALMSG-SA "U"
  DUMP-NAME "smartschedulerjobstatus"
  TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "SmartDBtrgs/crSSchedulerJobStatus.p" CRC "?" 

ADD FIELD "SchedulerJobStatusGuid" OF "SmartSchedulerJobStatus" AS character 
  FORMAT "x(36)"
  INITIAL ""
  LABEL "Job Status ID"
  POSITION 2
  MAX-WIDTH 72
  COLUMN-LABEL "Job Status ID"
  ORDER 10

ADD FIELD "SchedulerJobGuid" OF "SmartSchedulerJobStatus" AS character 
  FORMAT "x(36)"
  INITIAL ""
  LABEL "Job Guid"
  POSITION 3
  MAX-WIDTH 72
  COLUMN-LABEL "Job Guid"
  ORDER 20

ADD FIELD "ScheduleDateTime" OF "SmartSchedulerJobStatus" AS datetime-tz 
  FORMAT "99/99/9999 HH:MM:SS.SSS+HH:MM"
  INITIAL ?
  LABEL "Scheduled Job Execution"
  POSITION 4
  MAX-WIDTH 12
  COLUMN-LABEL "Scheduled Job Execution"
  ORDER 30

ADD FIELD "Recurring" OF "SmartSchedulerJobStatus" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Recurring"
  POSITION 5
  MAX-WIDTH 1
  COLUMN-LABEL "Recurring"
  ORDER 40

ADD FIELD "JobStatus" OF "SmartSchedulerJobStatus" AS character 
  DESCRIPTION "(ENUM SchedulerJobStatusEnum)"
  FORMAT "x(20)"
  INITIAL ""
  LABEL "Job Status"
  POSITION 6
  MAX-WIDTH 40
  COLUMN-LABEL "Job Status"
  ORDER 50

ADD FIELD "StatusText" OF "SmartSchedulerJobStatus" AS character 
  FORMAT "x(40)"
  INITIAL ""
  LABEL "Status Text"
  POSITION 7
  MAX-WIDTH 80
  COLUMN-LABEL "Status Text"
  ORDER 60

ADD FIELD "Percentage" OF "SmartSchedulerJobStatus" AS integer 
  DESCRIPTION "Progress  (0..100)"
  FORMAT "zz9"
  INITIAL "0"
  LABEL "Progress"
  POSITION 8
  MAX-WIDTH 4
  COLUMN-LABEL "Progress"
  ORDER 70

ADD FIELD "MaxExecutionDelay" OF "SmartSchedulerJobStatus" AS integer 
  FORMAT "zzzz9"
  INITIAL "0"
  LABEL "Max. Delay"
  POSITION 9
  MAX-WIDTH 4
  COLUMN-LABEL "Max. Delay"
  ORDER 80

ADD FIELD "Cancel" OF "SmartSchedulerJobStatus" AS logical 
  FORMAT "yes/no"
  INITIAL "no"
  LABEL "Cancel Req."
  POSITION 10
  MAX-WIDTH 1
  COLUMN-LABEL "Cancel Req."
  ORDER 90

ADD FIELD "StartDateTime" OF "SmartSchedulerJobStatus" AS datetime-tz 
  FORMAT "99/99/9999 HH:MM:SS.SSS+HH:MM"
  INITIAL ?
  LABEL "Start DateTime"
  POSITION 12
  MAX-WIDTH 12
  COLUMN-LABEL "Start DateTime"
  ORDER 110

ADD FIELD "FinishedDateTime" OF "SmartSchedulerJobStatus" AS datetime-tz 
  FORMAT "99/99/9999 HH:MM:SS.SSS+HH:MM"
  INITIAL ?
  LABEL "Finished DateTime"
  POSITION 13
  MAX-WIDTH 12
  COLUMN-LABEL "Finished DateTime"
  ORDER 120

ADD FIELD "JobParamter" OF "SmartSchedulerJobStatus" AS clob 
  DESCRIPTION "XML/JSON Serialized parameter  instance"
  FORMAT "x(8)"
  INITIAL ?
  POSITION 14
  LOB-AREA "LOB"
  LOB-BYTES 104857600
  LOB-SIZE 100M
  CLOB-CODEPAGE "UTF-8"
  CLOB-COLLATION "basic"
  CLOB-TYPE 2
  ORDER 130

ADD FIELD "ContextDataSet" OF "SmartSchedulerJobStatus" AS clob 
  DESCRIPTION "optionally Inherit context-dataset from the session that planned this job"
  FORMAT "x(8)"
  INITIAL ?
  POSITION 15
  LOB-AREA "LOB"
  LOB-BYTES 104857600
  LOB-SIZE 100M
  CLOB-CODEPAGE "UTF-8"
  CLOB-COLLATION "basic"
  CLOB-TYPE 2
  ORDER 140

ADD FIELD "UserGuid" OF "SmartSchedulerJobStatus" AS character 
  FORMAT "x(36)"
  INITIAL ""
  LABEL "UserGuid"
  POSITION 17
  MAX-WIDTH 72
  COLUMN-LABEL "UserGuid"
  ORDER 160

ADD FIELD "DataBaseConnections" OF "SmartSchedulerJobStatus" AS character 
  DESCRIPTION "Database connections (when not already conneced by scheduler agent)"
  FORMAT "x(120)"
  INITIAL ""
  LABEL "DataBaseConnections"
  POSITION 18
  MAX-WIDTH 240
  COLUMN-LABEL "DataBaseConnections"
  ORDER 170

ADD FIELD "ClientPrincipal" OF "SmartSchedulerJobStatus" AS raw 
  FORMAT "x(80)"
  INITIAL ""
  POSITION 19
  MAX-WIDTH 160
  ORDER 180

ADD FIELD "JobName" OF "SmartSchedulerJobStatus" AS character 
  FORMAT "x(40)"
  INITIAL ""
  LABEL "JobName"
  POSITION 20
  MAX-WIDTH 80
  COLUMN-LABEL "JobName"
  ORDER 35

ADD FIELD "SchedulerJobPlanGuid" OF "SmartSchedulerJobStatus" AS character 
  FORMAT "x(36)"
  INITIAL ?
  LABEL "Job Status ID"
  POSITION 21
  MAX-WIDTH 72
  COLUMN-LABEL "Job Status ID"
  ORDER 25

ADD INDEX "JobStatus" ON "SmartSchedulerJobStatus" 
  AREA "Index"
  UNIQUE
  PRIMARY
  INDEX-FIELD "SchedulerJobStatusGuid" ASCENDING 

ADD INDEX "Job" ON "SmartSchedulerJobStatus" 
  AREA "Index"
  INDEX-FIELD "SchedulerJobGuid" ASCENDING 
  INDEX-FIELD "Recurring" ASCENDING 

ADD INDEX "JobStatusCancelSchedule" ON "SmartSchedulerJobStatus" 
  AREA "Index"
  INDEX-FIELD "JobStatus" ASCENDING 
  INDEX-FIELD "Cancel" ASCENDING 
  INDEX-FIELD "ScheduleDateTime" ASCENDING 

ADD INDEX "SchedulerJobPlanGuid" ON "SmartSchedulerJobStatus" 
  AREA "Index"
  INDEX-FIELD "SchedulerJobPlanGuid" ASCENDING 
  INDEX-FIELD "ScheduleDateTime" ASCENDING 
  INDEX-FIELD "JobStatus" ASCENDING 

ADD INDEX "SchedulerJobPlanGuid2" ON "SmartSchedulerJobStatus" 
  AREA "Index"
  INDEX-FIELD "SchedulerJobPlanGuid" ASCENDING 
  INDEX-FIELD "JobStatus" ASCENDING 
  INDEX-FIELD "ScheduleDateTime" ASCENDING 

.
PSC
cpstream=ISO8859-1
.
0000015613