DBMS Jobs V's user scheduler Job

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • flossy
    New Member
    • Oct 2008
    • 1

    DBMS Jobs V's user scheduler Job

    Hi,
    We have some database jobs(DBMS) running on our 9i Oracle database.

    We have 1 new application that is now running on 10g.

    For some reason the development team of this 10g application seemed to have used a different type of database job that the one's I am used to seeing within toad.

    For those that are in the 9i database I can see them by
    select + from user_jobs
    However in the 10g database, I need to run the following command
    select * from user_scheduler_ job

    I'm trying to find out the difference between these 2 way of scheduling database jobs and in particular how we are going to monitor these goingforward.

    Any help would be appreciated..
    Thanks...
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    you can use either DBMS_JOBS or DBMS_SCHEDULER package to run your jobs.

    USER_SCHEDULER_ JOBS displays information about the Scheduler jobs owned by the current user. Its columns (except for OWNER) are the same as those in ALL_SCHEDULER_J OBS.

    Comment

    Working...