DBMS job
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: DBMS job

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    Hi,
    Can any1 expalian what dbms job is how do go about with 1?

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    DBMS_JOB is oracle provided Package which provides Job management features. Follow this thread for documentation on this package.

    http://www.dbasupport.com/forums/sho...threadid=12877

    Reddy,Sam

  3. #3
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    Don't forget you can always schedule a job through OEM's GUI interface.
    (If your running OEM that is!)

    Cheers
    Moff.

  4. #4
    Join Date
    Jun 2001
    Posts
    316
    hi
    I use this to craete a job in queue

    VARIABLE jobno NUMBER;
    BEGIN
    DBMS_JOB.SUBMIT(:jobno,'update test set id=nvl(id,1)+1', SYSDATE, 'SYSDATE + 1/72');
    COMMIT;
    END;
    /

    But the jobno give sme a problem!!!!


  5. #5
    Join Date
    Jun 2001
    Posts
    316
    just a reminder

  6. #6
    Join Date
    Aug 2000
    Posts
    462
    What does this mean?

    But the jobno give sme a problem!!!!

    What problem? What happens?

    have you queried the data dictionary to see what's going on?

    SELECT job, next_date, next_sec, failures, broken
    FROM user_jobs;
    Oracle DBA and Developer

  7. #7
    Join Date
    Jun 2001
    Posts
    316
    Basically i want to crate a job....
    But i acnnot...
    How do i go 'bout to do that

    thank u

  8. #8
    Join Date
    Nov 2000
    Posts
    245

    what error you get?
    do you have snp process running?

  9. #9
    Join Date
    Jun 2001
    Posts
    316
    ya

    ALTER SYSTEM ENABLE RESTRICTED SESSION;

    i this the 1?

    i am really new to this..pls help me

    thanx

  10. #10
    Join Date
    Jun 2001
    Posts
    316
    a reminder

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