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;| Code Example |
|---|
| Sql :: sql paging query |
| Sql :: how to lock table in mysql |
| Sql :: wherein sql |
| Sql :: create database in mysql |
| Sql :: create delete procedure mysql |
| Sql :: average sql |
| Sql :: postgresql remove new line from string |
| Sql :: sql server date format yyyy-MM-ddThh:mm:ss |
| Sql :: how to set up a trigger in sql |
| Sql :: sql between |
| Sql :: rename table sqlite |
| Sql :: regexp in mysql |
| Sql :: postgres how to index a column |
| Sql :: partition by sql server |
| Sql :: mysql date equals to current_date plus days |
| Sql :: select top 3 sql |
| Sql :: sql currency format |
| Sql :: sql insert column |
| Sql :: sql cnvert bit to nvarchar |
| Sql :: user_dependencies |
| Sql :: drush run sql select |
| Sql :: htaccess allow index |
| Sql :: date sql |
| Sql :: sql server convert to guid |
| Sql :: mysql random |
| Sql :: delete rows from table sql |
| Sql :: how to get connect string from mysql database |
| Sql :: mysql table schema |
| Sql :: sql add column with default value |
| Sql :: identify primary key in oracle table |