Solution: Scheduled tasks in Oracle 11g

Development | Databases
Description
How to fix? Please help..
Attachments
No attachments.
Solutions
Create a job that runs every minute at 0 seconds, but it takes 80 seconds to complete. As you can see from the difference between REQ_START_DATE and ACTUAL_START_DATE (and LOG_DATE), each consequent run waits for the previous one to complete. This is the simplest configuration, but you can change this behaviour with the max_run_duration parameter that allows you to limit the duration of a job (you need to handle the event that's raised by this). Or if you used scheduler windows, jobs could be set to automatically stop when the window closes with the stop_on_window_close parameter.
on July 02nd, 2018 (5:38 pm)
What masters said
You must sign in to comment!!
All comments
This solution has not been commented yet.
We use cookies to give you the best possible experience on our site. By continuing to use the site you agree to our use of cookies. Find out more Accept