scheduler_activate_job

Use

You activate a Scheduler job.

To activate a job, the operational state of the database instance is irrelevant. Whether the scheduler is enabled or disabled is likewise irrelevant.

The activated job, however, is only actually executed if the Scheduler is activated and if you have the server authorization for executing the DBM command defined in the job (see: scheduler_start).

See also:

Concepts of the Database System, Automating Administration Tasks

Prerequisites

?     The Scheduler job which is to be activated has been created (see: scheduler_create_job).

?     You have the server authorization SchedulerMgm or you are the owner of the job and have the server authorization Scheduling.

Syntax

scheduler_activate_job <job_ID>

<job_ID>

Job ID of the Scheduler job to be activated

Reply

OK

In the event of errors, see Reply Format.

Example

Call the Database Manager CLI, log on as operator DBM with password OLEG, connect to the database instance DEMODB, activate the Scheduler job with the job ID 1:

>dbmcli -u OLEG,MONDAY -d DEMODB scheduler_activate_job 1

OK