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

0 vote144 views1 answer
Sql select min
SQL
3 votes137 views3 answers
Sql last week
SQL
1 vote135 views1 answer
Spring postgresql reset auto increment to 0
SQL
7 votes173 views1 answer
Show line number in sql server
SQL
0 vote159 views1 answer
Mysql insert into select transaction c#
SQL
16 votes155 views3 answers
Get count of duplicate records
SQL
0 vote140 views1 answer
Update and keep original value sql
SQL
0 vote158 views1 answer
Selecting all columns from table sql database
SQL
0 vote162 views1 answer
Oracle step procedure
SQL
0 vote145 views1 answer
Wordpress sql change site url
SQL