Breaking News: Grepper is joining You.com. Read the official announcement!

oracle create job if not exists

VasteMonde answered on August 27, 2021 Popularity 2/10 Helpfulness 1/10

answer oracle create job if not exists

oracle create job if not exists

Comment

DECLARE
    l_job_exists NUMBER;
BEGIN
    SELECT count(*) INTO l_job_exists
    FROM all_scheduler_jobs WHERE job_name = 'job_name' AND OWNER = 'owner';
    IF l_job_exists = 1 THEN
        dbms_scheduler.drop_job(job_name => 'job_name');
    END IF;
END;
/
BEGIN DBMS_SCHEDULER.CREATE_JOB(job_name => '"owner"."job_name"', ...); END;

Popularity 2/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: not-exists oracle sql

Link to this answer
Share Copy Link

Contributed on Aug 27 2021

VasteMonde

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

oracle create job if not exists

Contents

More Related Answers

oracle create job if not exists

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.