Managing Schedules

Enabling/Disabling a Schedule

SQL

SYSADMIN.EnableSchedule(<IN biginteger id>, <IN boolean enabled> NOT NULL, <IN string uuid>)

This procedure takes the following parameters:

Parameter	Description
`id`	ID of the schedule to be enabled or disabled
`enabled`	Specifies if the schedule should be enabled or disabled; may be either `TRUE` or `FALSE`
`uuid`	UUID of the schedule to be enabled or disabled

The schedule ID or job UUID must be specified.

Deleting a Schedule

SQL

SYSADMIN.DeleteSchedule( <IN biginteger id>, <IN string uuid>  )

This procedure takes the following parameter:

Parameter	Description
`id`	ID of the schedule to be deleted
`uuid`	UUID of the schedule to be deleted

Modifying a Schedule

SQL

SYSADMIN.UpdateSchedule( <IN biginteger id>, <IN string type>, <IN biginteger intervl>, <IN biginteger startDelay>, <IN string cronExpression>, <IN boolean enabled>, <IN biginteger chainedToScheduleId>, <IN string chainCondition>, <IN string chainString>, <IN string owner>, <IN string queueHandler>, <IN string uuid>, <IN string timezone> )

This procedure takes the following parameters:

To view the full table, click the expand button in its top right corner

Parameter	Description
`id`	ID of the schedule to be modified
`type`	Can take one of four possible values; depending on the value, some other parameters are required or disregarded: `interval`: `intervl` and `startDelay` parameters are used, `cronExpression`, `chainedToScheduleId`, and `chainCondition` are disregarded `cron`: `cronExpression` and `startDelay` parameters are used, `intervl`, `chainedToScheduleId`, and `chainCondition` are disregarded `once`: only `startDelay` and the enabled parameters are used `chained`: only `chainedToScheduleId` and `chainCondition` parameters are used
`intervl`	How often to repeat the job in minutes. If this parameter is used, the `cronExpression` parameter is disregarded
`startDelay`	Initial delay before running the job (only before the 1st iteration, all subsequent iterations are fired in accordance with interval/cron schedule settings)
`cronExpression`	Provides the Quartz Cron Expression to specify the schedule. If this parameter is used, the `intervl` parameter is disregarded, but the `startDelay` parameter is used. This means that depending on the actual configuration, the event may or may not fire at this specific time; however, the trigger will not fire before this time. If we start a schedule at 17:59 with cron string having '18:00' and set the start delay to 2 minutes, the event will actually fire at 18:00 of the following day
`enabled`	Enables the execution of the schedule according to `interval` or `cronExpression` parameters
`chainedToScheduleId`	ID of the parent schedule, i.e. this schedule will be executed after the parent schedule if `chainCondition` is fulfilled
`chainCondition`	Can take the following possible values: `UNCONDITIONAL`: this schedule is always executed after the parent schedule) `SUCCESS`: this schedule is only executed if the parent schedule succeeds `FAILURE`: this Schedule is only executed if the parent Schedule fails If `NULL` is provided, `UNCONDITIONAL` is set as default
`chainString`	Expression string when complex dependencies are used; see the section further down for a detailed explanation. If the created schedule depends only on one other schedule then either `chainedToScheduleId` is not `NULL` and `chainString` is `NULL`, or `chainedToScheduleId` is `NULL`, `chainCondition` is `NULL`, and `chainString` is not `NULL`
`owner`	Name of the schedule owner. Owner could be set to the value that is not equal to the current user only by members of `admin-role`
`queueHandler`	Name of queue handler
`uuid`	UUID of the schedule to be modified
`timezone`	Define the timezone for the schedule (`timezoneId` column from the SYSADMIN.Timezones table). Time zone will only affect schedules of type `CRON`

The schedule ID or UUID must be specified.

Parameter owner can also be modified by using procedure SYSADMIN.changeResourceOwnerAndExecutor()

Resetting a Schedule

SYSADMIN.resetSchedule

This procedure resets a schedule.

SQL

SYSADMIN.resetSchedule( <IN biginteger id> )

This procedure takes the following parameter:

Parameter	Description
`id`	ID of the schedule to be reset

Please note that it creates the mark so that the schedule counts its conditions from that point in time.

SYSADMIN.resetAtomicSchedule

deprecated