Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Oracle Database + Options
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: May 8, 2013 5:11 PM by
May 8, 2013 5:11 PM
I have this create_job
job_type => 'CHAIN',
job_action => 'ETL_TEST_CHAIN',
start_date => '08-MAY-13 5.45.00PM',
repeat_interval => 'FREQ = MINUTELY; INTERVAL=30; BYHOUR = 6,7',
enabled => TRUE,
comments => 'Run tests for source and target data.');
The start date is '08-MAY-13 5.45.00PM', repeat_interval => 'FREQ = MINUTELY; INTERVAL=30; BYHOUR = 6,7',
It is supposed to fire once at 5:45PM, and then at 6PM and then at 6:30 PM. and then at 7PM.
I ran this select * from user_scheduler_jobs;
and it clearly indicates it is supposed to run at 5:45 PM. BUt it did not run, is there any way to find out what happened to the scheduled job,
I ran this
WHERE job_name = 'ETL_TEST_JOB'
ORDER BY REQ_START_DATE desc; and I do not see it there as well.
This content has been marked as final.
Show 0 replies