-
Hi,
whats the difference between submitting a Job using dbms_job package and submitting a job using OEM.
which one is more preferrable.
Thanks
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
Ronnie,
No big difference internally. I have seen people preferring OEM.
Thanks,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
Originally posted by samdba
Ronnie,
No big difference internally. I have seen people preferring OEM.
Thanks,
Dont the jobs created through OEM use the intelligent agent.
When you clean start the agent (by deleting the services.ora,*.q and some other files ) you lose all your scheduled Jobs and events, but not the dbms_job jobs.
This means that there is some difference, but whats that.
Also are there any reasons why people prefer OEM rather than dbms_job to schedule jobs.
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
why I prefer OEM Jobs.
Hi there,
I think the main readon why i prefer OEM jobs is that you get email notification etc of when the job starts, if it fails etc. Also it allows you do other stuff such as run reports and have'fixit' jobs. IE if the database is down, run the fixit-job that starts it up automatically.
If you think of dbms_job being used to schedule only PLSQL jobs to run, and OEM jobs to schedule database (import/export etc) and OS jobs to run and then you can see the diffrence.
_Bob
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|