Use this DBM command to delete a scheduler job.
You can delete both active and inactive jobs. Before you do so, however, 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 is irrelevant. Likewise, it is irrelevant whether the scheduler is on or off.
The job to be deleted does not have any successors.
You have the server permission SchedulerMgm or you are the owner of the job and have the server authorization Scheduling.
scheduler_delete_job <job_ID>
Option | Description |
---|---|
<job_ID> | Job ID of the Scheduler job to be activated |
Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the DEMODB database, delete the scheduler job with the job ID 1:
>dbmcli -u OLEG,MONDAY -d DEMODB scheduler_delete_job 1
OK
Database Administration, Automating Administration Tasks