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

10 votes275 views1 answer
Oracle all_dependencies
SQL
0 vote194 views1 answer
SQL isnumeric DB2
SQL
3 votes205 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
13 votes203 views4 answers
What is sql
SQL
-1 vote193 views2 answers
Get day in sql
SQL
38 votes277 views6 answers
Alter table mysql
SQL
0 vote202 views1 answer
Oracle procedure chain step
SQL
0 vote240 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote250 views1 answer
Get foreign table names mysql
SQL
1 vote202 views1 answer
Type int in mysql maxlenght
SQL