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 vote121 views1 answer
Rename constraint postgresql
SQL
0 vote119 views1 answer
Luu ckeditor vao mysql
SQL
0 vote126 views1 answer
Character count sql
SQL
0 vote78 views1 answer
Split a string with expression and get the last value of split sql
SQL
4 votes131 views1 answer
Oracle nls_date_format
SQL
0 vote71 views0 answer
SQL
0 vote140 views1 answer
Ms sql print more than 1 variable
SQL
0 vote120 views1 answer
Postgresql alter column nullable
SQL
0 vote118 views1 answer
Report in database
SQL
1 vote127 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL