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

1 vote273 views1 answer
Sql try catch
SQL
5 votes294 views1 answer
Sql select ciunt
SQL
0 vote297 views1 answer
How to reset the database value in SQL server
SQL
0 vote307 views1 answer
Sql quary stuf
SQL
2 votes302 views5 answers
Eloquest how to select one specific column in database
SQL
2 votes291 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
1 vote301 views1 answer
How to lock table in mysql
SQL
0 vote299 views1 answer
How to start my sql server on mac
SQL
4 votes266 views1 answer
Wilayah indonesia database
SQL
0 vote271 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL