Home > Technical > Table Definitions > SCHEDJOB

SCHEDJOB

Lists the jobs which are to be run in a session by the Schedule Processor.

Column Type Description

INTDAYOFWEEK

INT(4)

The session to which this job belongs. 2-8= Monday-Sunday PM.12-18= Monday-Sunday AM.19-25= Misc 1 to Misc 7.

STRJOBTYPE

VARCHAR(10)

The type of job. ‘Default’

LINTORDER

INT(4)

A number used to determine the order in which this process should be run compared to others in the same session.

CTRCODE

INT

Unique code assigned by the system.

STRPROCEDURE

VARCHAR(50)

The name of the process to be performed.

link.gif (858 bytes) PROCESS.strReportName

STRPARAM1

VARCHAR(50)

The first parameter for this job.

STRPARAM2

VARCHAR(50)

 

STRPARAM3

VARCHAR(50)

 

STRPARAM4

VARCHAR(50)

 

STRPARAM5

VARCHAR(50)

 

STRPARAM6

VARCHAR(50)

 

STRPARAM7

VARCHAR(50)

 

STRPARAM8

VARCHAR(50)

 

STRPARAM9

VARCHAR(50)

 

STRPARAM10

VARCHAR(50)

 

STRPARAM11

VARCHAR(50)

 

STRPARAM12

VARCHAR(50)

 

STRPARAM13

VARCHAR(50)

 

STRPARAM14

VARCHAR(50)

 

STRPARAM15

VARCHAR(50)

 

YSNRUNIFERROR

VARCHAR(1)

If ‘T’ this job will run even if a previous job in the session had an error.

STRGUID

CHAR(38)

 

INTLOCALEID

INT(4)

 

YSNREPLOCATIONPERGROUP

VARCHAR(1)

 

STRPARAM16

VARCHAR(30)

 

STRPARAM17

VARCHAR(30)

 

STRPARAM18

VARCHAR(30)

 

STRPARAM19

VARCHAR(30)

 

STRPARAM20

VARCHAR(30)

 

 

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)