Submit job using dbms_job or OEM

[ronnie]

Hi,

whats the difference between submitting a Job using dbms_job package and submitting a job using OEM.

which one is more preferrable.

Thanks

[samdba]

Ronnie,

No big difference internally. I have seen people preferring OEM.

Thanks,

[ronnie]

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.

[bmycroft]

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