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 vote348 views1 answer
Finding leap year in sql
SQL
0 vote345 views1 answer
Get substract count sql
SQL
25 votes312 views3 answers
How to use a database to see tables mysql
SQL
-2 votes312 views2 answers
Union all in sql
SQL
0 vote316 views2 answers
Mysql calcular idade
SQL
4 votes280 views3 answers
Count with where
SQL
1 vote348 views1 answer
Import sql file from laravel
SQL
1 vote303 views1 answer
Sql restore backup query
SQL
2 votes288 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote293 views1 answer
Value of sold product using having and group by in sql
SQL