Enabling/Disabling a Schedule

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

このプロシージャは以下のパラメータを取ります:

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

スケジュールIDまたはジョブUUID  を指定する必要があります。

uuid parameter in SYSADMIN.enableSchedule is available since v4.4

Deleting a Schedule

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

このプロシージャは以下のパラメータを取ります:

Parameter

Description

id

ID of the schedule to be deleted

uuid

UUID of the schedule to be deleted

uuid parameter in SYSADMIN.DeleteSchedule is available since v4.1

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>, <IN string uuid>, <IN string timezone> )

このプロシージャは以下のパラメータを取ります:

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, cronExpressionchainedToScheduleId, 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

スケジュールID またはUUID  を指定する必要があります。

パラメータ所有者は、プロシージャ SYSADMIN.changeResourceOwnerAndExecutor()を使用して変更することもできます

owner parameter in SYSADMIN.updateSchedule is available since v4.1

uuid parameter in SYSADMIN.updateSchedule is available since v4.5

SYSADMIN.changeResourceOwnerAndExecutor procedure is available since v4.5

timezone column in SYSADMIN.createSchedule is available since v4.8 

Resetting a Schedule

SYSADMIN.resetSchedule

このプロシージャはスケジュールをリセットします。

SYSADMIN.resetSchedule( <IN biginteger id> )

このプロシージャは以下のパラメータを取ります:

Parameter

Description

id

ID of the schedule to be reset

このマークはスケジュールがその時点からその条件をカウントするように作成されることに注意してください。

SYSADMIN.resetSchedule is available since v4.0.7

SYSADMIN.resetAtomicSchedule

非推奨

See Also

Create Dependent Replication Jobs依存レプリケーションジョブを作成し、そのスケジュールを定義する方法については、ステップバイステップのガイドを参照してください。