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

15 votes361 views3 answers
Postgresql change column type
SQL
0 vote339 views1 answer
Postgresql certain first 4 characters in string
SQL
2 votes381 views3 answers
Xampp mysql database not starting
SQL
0 vote340 views1 answer
Subquery aggregation
SQL
0 vote351 views1 answer
Flexible search query delete table
SQL
0 vote325 views1 answer
Mariadb used space
SQL
2 votes361 views1 answer
Get the mysql table columns data type mysql
SQL
1 vote322 views1 answer
Real world example of nosql
SQL
0 vote356 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
0 vote327 views1 answer
Sql counter column
SQL