Enabling/Disabling a Schedule
SYSADMIN.EnableSchedule(<
IN
biginteger id>, <
IN
boolean enabled>
NOT
NULL
, <
IN
string uuid>)
このプロシージャは以下のパラメータを取ります:
Parameter | Description |
---|---|
| ID of the schedule to be enabled or disabled |
| Specifies if the schedule should be enabled or disabled; may be either |
| 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 of the schedule to be deleted |
| 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 of the schedule to be modified |
| Can take one of four possible values; depending on the value, some other parameters are required or disregarded:
|
| How often to repeat the job in minutes. If this parameter is used, the |
| Initial delay before running the job (only before the 1st iteration, all subsequent iterations are fired in accordance with interval/cron schedule settings) |
| Provides the Quartz Cron Expression to specify the schedule. If this parameter is used, the |
| Enables the execution of the schedule according to |
| ID of the parent schedule, i.e. this schedule will be executed after the parent schedule if |
| Can take the following possible values:
If |
| 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 |
| Name of the schedule owner. Owner could be set to the value that is not equal to the current user only by members of |
| Name of queue handler |
| UUID of the schedule to be modified |
| Define the timezone for the schedule ( |
スケジュール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 of the schedule to be reset |
このマークはスケジュールがその時点からその条件をカウントするように作成されることに注意してください。
SYSADMIN.resetSchedule
is available since v4.0.7
SYSADMIN.resetAtomicSchedule
非推奨
See Also
Create Dependent Replication Jobs依存レプリケーションジョブを作成し、そのスケジュールを定義する方法については、ステップバイステップのガイドを参照してください。