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 vote345 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
1 vote401 views1 answer
Isnull sql server
SQL
1 vote416 views1 answer
T-sql disable system versioning
SQL
0 vote365 views1 answer
Do postgresql
SQL
1 vote352 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote357 views1 answer
Grepper sql workbench download
SQL
0 vote378 views1 answer
One table with another
SQL
33 votes362 views2 answers
Postgres how to add field created at
SQL
4 votes361 views3 answers
Postgres set default value
SQL
10 votes378 views2 answers
Sql pagination offset
SQL