Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle drop job

BEGIN
  dbms_scheduler.drop_job(job_name => 'MY_OWNER.MY_JOB');
END;
Comment

oracle drop job

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;
Comment

PREVIOUS NEXT
Code Example
Sql :: sql find text in sp 
Sql :: mysql status 
Sql :: guid to string sql 
Sql :: loading local data is disabled mysql 
Sql :: oracle all tables in schema 
Sql :: sql disable trigger 
Sql :: . ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid). 
Sql :: mysql where column not integer 
Sql :: uninstall mysql on ubuntu 
Sql :: view column data type sql 
Sql :: mysql stop password policy 
Sql :: mysql return 0 if null 
Sql :: sql server get users 
Sql :: UseSqlServer no definition 
Sql :: mysql drop database if exists 
Sql :: installer postgresql sur ubuntu 
Sql :: mysql copy table with new name 
Sql :: select users 
Sql :: sql server check if temp table exists 
Sql :: mysql command line connect 
Sql :: postgres stop server mac 
Sql :: sqlite list columns 
Sql :: postgres DROP and create contraint 
Sql :: athena drop partition 
Sql :: grant schema permissions postgres 
Sql :: search column name sql 
Sql :: oracle set sequence value to max(id) 
Sql :: having count greater than 1 mysql 
Sql :: postgres killing connections on db 
Sql :: how to copy data of a table from another database to table of anaother database 
ADD CONTENT
Topic
Content
Source link
Name
1+7 =