Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Database + Options
This discussion is archived
on May 8, 2013 10:11 PM by 934896
May 8, 2013 10: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.
I have the same question
Show 0 Likes
This content has been marked as final.
Show 0 replies