Show TOC

scheduler_deactivate_jobLocate this document in the navigation structure

Use

With this command you deactivate a scheduler job.

Afterwards, the job remains in the list of scheduler jobs but is no longer executed. Scheduler jobs that were defined as successors of a deactivated job are neither executed any longer.

For deactivating a job, the operational state of the database is irrelevant. Likewise, it is irrelevant whether the scheduler is on or off.

Prerequisites

You have the server permission SchedulerMgm or you are the owner of the job and have the

Scheduling server authorization.

Structure

scheduler_deactivate_job <job_ID>

Table 1: Options

Option

Description

<job_ID>

Job ID of the Scheduler job to be activated

Result

OK

In the event of errors, see Reply Format.

Example

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

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

OK

More Information

Database Administration, Automating Administration Tasks