|
Re: Drawbacks if any in using DBMS_JOB [message #74587 is a reply to message #74586] |
Wed, 12 January 2005 00:12 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
You only need to compare DBMS_JOB with DBMS_SCHEDULER in Oracle 10g to realize that DBMS_JOB has serious limitations. Here are a few:
1. Cannot execute OS commands
2. Cannot define job schedules and windows
3. Must use difficult to read DATE expressions (no calendaring support)
4. Cannot easily associate jobs with resource plans
Etc...
Best regards.
Frank
|
|
|