What is DBMS_SCHEDULER used for. Is this available in all versions of Oracle? Kindly let me know the usage and purpose of this.
Printable View
What is DBMS_SCHEDULER used for. Is this available in all versions of Oracle? Kindly let me know the usage and purpose of this.
Hi,
Oracle Database provides advanced scheduling capabilities through Oracle Scheduler and the Scheduler is been configured & operated by the package, [B]DBMS_SCHEDULER [/B]
[B]This new package in Oracle10g offers much more robust database-level job scheduling.[/B]
The Scheduler offers far more functionality than the [B]DBMS_JOB [/B]package, which was the previous Oracle Database job scheduler.
The following links will help in detailed explanation & attain a clear understanding with examples
[URL="http://www.databasejournal.com/features/oracle/article.php/3400561"]Oracle 10g Scheduler[/URL]
[URL="http://www.oradev.com/dbms_scheduler.jsp"]Job scheduling with DBMS_SCHEDULER [/URL]