Managing Schedules
Enabling/Disabling a Schedule
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
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
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> )
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:
|
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:
If |
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 |
Resetting a Schedule
SYSADMIN.resetSchedule
This procedure resets a schedule.
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
See Also
Create Dependent Replication Jobs for a step-by-step guide on how to create a dependent replication job and define a schedule for it