scheduler_deactivate_job 

Use

You deactivate a Scheduler job.

The job then remains in the list of Scheduler jobs but is no longer executed. Scheduler jobs that were defined as successors of a deactivated job are also no longer executed.

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

See also:

Concepts of the Database System, Automating Administration Tasks

Prerequisites

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

Syntax

scheduler_deactivate_job <job_ID>

<job_ID>

Job ID of the Scheduler job to be deactivated

Reply

OK

In the event of errors, see Reply Format.

Example

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

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

OK