×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Jon Nickerson
Added: Dec 8, 2017 6:14 PM
Views: 1
Tags: no tags
  1. SELECT
  2.   job_name,
  3.   job_action,
  4.   enabled,
  5.   run_count,
  6.   Failure_count,
  7.   last_start_date,
  8.   next_run_date
  9. FROM all_scheduler_jobs
  10. WHERE job_name LIKE 'ETLJ_LUO_SMSAUTO%';
  11.  
  12.  
  13. BEGIN
  14.   DBMS_SCHEDULER.SET_ATTRIBUTE (
  15.    name         =>  '',
  16.    attribute    =>  'job_action',
  17.    VALUE        =>  '');
  18. END;
  19.  
  20.