Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS scheduler v/s Cron

510084Apr 6 2007 — edited Dec 5 2008
Can please someone elaborate why to use DBMS scheduler instead of UNIX/Linux cron execute shell scripts. Why is this better?

I know few...

1) Make one job's execution dependent on the completion of another job.
2) We can group jobs for resource allocation and prioritization.
3) We can set different resource plans to affect your jobs at different times.
4) Job execution times are set and logged in TIMESTAMP WITH TIME ZONE, not DATE, allowing for much greater precision

Thanks...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2009
Added on Apr 6 2007
#database-key-features, #scheduler
13 comments
11,840 views