Submit job using dbms_job or OEM
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Submit job using dbms_job or OEM

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    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.

  2. #2
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    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

  3. #3
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    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.

  4. #4

    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
  •  


Click Here to Expand Forum to Full Width