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 vote192 views1 answer
Drop check command
SQL
1 vote113 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
2 votes119 views1 answer
How to make multiple keys as primary in bdms
SQL
1 vote123 views1 answer
Get parameter value in mysql trigger
SQL
22 votes134 views1 answer
Mysql workbench
SQL
3 votes105 views1 answer
Index using in query plsql
SQL
0 vote109 views1 answer
Move table to a different schema
SQL
0 vote110 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote101 views1 answer
Postgresql newline character
SQL
0 vote116 views1 answer
Mysql Like(searching in the string)
SQL