Oracle drop job if exists

DECLARE
    l_job_exists NUMBER;
BEGIN
    SELECT count(*) INTO l_job_exists FROM ALL_SCHEDULER_JOBS
    WHERE JOB_NAME = 'job_name' AND OWNER = 'owner_name';
    IF l_job_exists = 1 THEN
        dbms_scheduler.drop_job(job_name => 'owner_name.Job_name');
    END IF;
END;

Source: stackoverflow.com

Similar codes

2 votes267 views1 answer
Import large .sql files into lampp
SQL
3 votes272 views2 answers
Oracle grants
SQL
0 vote255 views1 answer
Power query datetime to date
SQL
2 votes282 views1 answer
Column names in oracle sql
SQL
0 vote262 views2 answers
Drop check constraint in ms sql
SQL
0 vote308 views1 answer
Creating sqeuence in oracle database
SQL
0 vote286 views1 answer
Sql if clause within where clause
SQL
0 vote289 views1 answer
Mysql cli output to a file
SQL
17 votes275 views2 answers
Mysql date to string
SQL
0 vote261 views1 answer
Download mysql database to excel in android studio
SQL