Schedules and Jobs

SYSADMIN.ScheduleJobExtraProperties

This table supplies information on all additional properties of jobs.

Column Name	Type	Description
`jobId`	biginteger	Job ID
`name`	string	Property name
`val`	string	Property value

SYSADMIN.ScheduleJobs

This table supplies information on jobs.

Column Name	Type	Description
`id`	biginteger	Job ID
`jobName`	string	Unique name
`jobType`	string	Job type (e.g. recommended optimization, cleanup, etc.)
`description`	string	Description of the current job
`script`	clob	Script data (specific for SQL jobs)
`disabled`	boolean	Flag to signal whether the job is enabled or disabled
`deletable`	boolean	Flag to signal whether jobs of a particular type may be deleted
`incremental`	boolean	Flag to signal whether jobs should be executed for an incremental update (specific for optimization jobs)
`newRowCheckExpression`	string	New row check expression (specific for incremental optimization jobs)
`identityExpression`	string	Identity expression (specific for incremental optimization jobs)
`deleteOldData`	boolean	Flag to signal if an incremental job should delete old data or not (specific for incremental optimization jobs)
`allowIndexCreation`	string	Types of indexes allowed for this optimization job (specific for optimization jobs)
`gatherNativeStats`	boolean	Flag to signal if native statistics should be gathered or not when a replication job is completed (specific for optimization jobs)
`indexCreationByStatus`	string	String representing the status that the indexes must have to be created after completing the replication
`groupId`	biginteger	Optimization ID (specific for optimization jobs)
`parallelRunsAllowed`	integer	Number of parallel runs allowed for the job
`retryCounter`	integer	Number of job retry attempts in case the job is failing
`retryDelay`	integer	Delay in seconds between the retry attempts
`runTimeout`	integer	Timeout configured individually for this job if any (in minutes)
`running`	boolean	Indicates if `scheduleJob` is currently running or not
`inQueue`	boolean	Indicates if `scheduleJob` is currently in a queue
`lastExecutionStatus`	string	Status of last execution of `scheduleJob`
`lastExecutionFailureReason`	string	Reason why the execution of `scheduleJob` failed
`creationDate`	timestamp	Timestamp when `scheduleJob` was created
`lastModifiedDate`	timestamp	Timestamp when `scheduleJob` was last modified
`creator`	string	Account that was used to create `scheduleJob`
`modifier`	string	Account that was used to last modify `scheduleJob`
`lastWarnings`	string	Warnings risen during the last job run if any
`owner`	string	Name of the job owner
`runAs`	string	Runner of the job (CALLER or OWNER)
`uuid`	string	Job UUID

uuid, owner, and runAs columns in SYSADMIN.ScheduleJobs are available since v4.1

SYSADMIN.Schedules

This table supplies information on schedules.

Column Name	Type	Description
`id`	biginteger	Schedule ID
`jobID`	biginteger	Job ID
`type`	string	Schedule type
`interval`	biginteger	Interval in minutes
`startDelay`	biginteger	Start delay in minutes
`cronExpression`	string	Cron expression
`enabled`	boolean	Flag to signal if the schedule is enabled or not
`chainString`	string	***
`nextFireTime`	timestamp	Timestamp of the next expected execution
`creationDate`	timestamp	Timestamp of schedule creation
`lastModifiedDate`	timestamp	Timestamp of schedule modification
`creator`	string	User who created the schedule
`modifier`	string	User who modified the schedule
`scheduleName`	string	Unique name for the schedule
`queueHandler`	string	Name of a queue handler
`owner`	string	Name of the schedule owner
`uuid`	string	Schedule UUID
`cronTimezone`	string	Time zone for schedule ("timezoneId" from SYSADMIN.Timezones)

uuid and owner columns in SYSADMIN.Schedules are available since v4.1

cronTimezone column in SYSADMIN.Schedules is available since v4.8

SYSADMIN.JobQueue

This table supplies information on jobs in queues.

Column Name	Type	Description
`id`	string	Job queue item ID
`position`	long	Position in the queue
`priority`	integer	Item priority
`vdbID`	biginteger	Virtual database ID
`jobID`	biginteger	Job ID
`scheduleID`	biginteger	Schedule ID
`queueHandler`	string	Queue handler name

SYSADMIN.JobQueueHandlersStats

This table supplies state thread pool information for each job queue handler.

Column Name	Type	Description
`id`	string	Id column
`threadName`	string	Name of the thread
`queueHandler`	string	Queue handler name
`desiredHandler`	string	Name of the queue handler which job is supposed to use
`vdbId`	biginteger	Id of the virtual database where the job should run
`jobId`	biginteger	Id of the running job
`scheduleId`	biginteger	Id of the schedule that triggered the job
`runId`	biginteger	Id of the job run in the `SYSLOG.JobLogs` system table
`startTime`	timestamp	Start time of the job
`jobName`	string	`jobName` value for the running job
`jobDescr`	string	Job description
`runState`	string	Service field providing debug information for our engineers

SYSADMIN.JobQueueHandlersStats table is available since v4.1

SYSADMIN.JobQueueStats

This table supplies information on job queue handlers statistics. There is a row for every queue handler and an additional row with queueHandler name <total> for total statistics.

Column Name	Type	Description
`queueHandler`	string	Queue handler name
`threadCount`	integer	Thread count of this queue handler
`maxQueueSize`	integer	Shows total max job queue size in <total> row. -1 for all other rows
`currentlyRunning`	integer	Number of currently running jobs
`totalRuns`	long	Number of finished job runs
`estimatedInQueue`	long	Number of jobs in the queue

owner and uuid columns in SYSADMIN.Schedules are available since v4.1

SYSADMIN.Timezones Table

This table supplies information about time zones and their UTC offset

Value	Description
`timezoneId`	Unique ID of the time zone itself
`timezoneName`	Time zone name
`currentOffset`	UTC offset currently applied to the time zone
`summerOffset`	Daylight saving time UTC offset of the time zone
`winterOffset`	Standard time UTC offset of the time zone

SYSADMIN.Timezones table is available since v4.8