Background documentationscheduler_delete_job Locate this document in the navigation structure

 

You use this DBM command to delete a Scheduler job.

You can delete both active and inactive jobs. Before you do so, however, you must make sure that the job to be deleted does not have any successors. Otherwise, the DBM command is aborted with an error message.

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

Prerequisites

  • The job to be deleted does not have any successors

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

Structure

scheduler_delete_job <job_ID>

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 the Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the DEMODB database instance, delete the Scheduler job with the job ID 1:

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

OK

More Information

Database Administration, Automating Administration Tasks