(PL/SQL) oracle database scheduler jobs - geekzspot

Copy this code and paste it in your HTML

database scheduler jobs
-- Show the times a job ran.
WHERE job_name = :JOB_NAME
;
-- Show job intervals (time difference between rows)
FROM all_scheduler_job_log
WHERE job_name = :JOB_NAME
;
?
;
?
?
;
?
?
-- Job Logs:
-- select * from user_scheduler_jobs;
-- select * from user_scheduler_job_run_details;
?
    l_job_name VARCHAR2(255) := 'metrics_log_job';
    dbms_scheduler.stop_job( job_name => l_job_name ); -- This handles ORA-27478: job ".." is running.
    dbms_scheduler.drop_job( job_name => l_job_name );
?
  dbms_scheduler.create_job 
  ( job_name        => l_job_name
  , job_type        => 'PLSQL_BLOCK'
  , job_action      => 'PROCEDURE_Name;' -- Don't forget the semicolon! Or you'll get ORA-06550: line 1, column 776: PLS-00103: Encountered the symbol "" when expecting one of the following: := . ( @ % ; The symbol ";" was substituted for "" to continue.
  , repeat_interval => 'freq=hourly;'
  , comments        => ''
  ); -- ORA-27486: insufficient privileges requires grant create job to <user> 
/
?
?
/*
-- SMTP setup
?
CONNECT / AS SYSDBA
?
begin
? DBMS_SCHEDULER.set_scheduler_attribute('email_server', 'smtp.mail.server:25');
end;
/
*/
?
?
 dbms_scheduler.add_job_email_notification 
 ( job_name   =>  'metrics_log_job'
 , events     =>  'job_failed'
 );
/
INSERT INTO release_log (name, description) VALUES ('metrics', 'weekly metrics log');

Source: http://snipplr.com/view/68798/oracle-database-scheduler-jobs/

2012 nfl mock draft iowa caucus lemonade diet steve jobs action figure chris jericho rose bowl johnny weir