I have a created a scheduled job to run on Oracle 11g database everyday night at 8PM. I could I create an email notification so that it will automatically send me an email when the Job finishes (completes its run)?
I attached my scheduled job, which calls an Oracle stored procedure.
name => 'TestJOB', force => TRUE);
DBMS_SCHEDULER.CREATE_JOB(job_name => 'MyJobName',
job_type => 'STORED_PROCEDURE',
job_action => 'procedurename',
start_date => to_timestamp_tz('01/10/2011 20:00:00 US/Central',
'mm/dd/yyyy hh24:mi:ss tzr'),
repeat_interval => 'FREQ=hourly; INTERVAL=6',
enabled => true,
auto_drop => false,
comments => 'Refreshes SoF tables');