Results 1 to 2 of 2

Thread: Dbms_job

  1. #1
    Join Date
    Jun 2003
    Posts
    294

    Lightbulb Unanswered: Dbms_job

    I'm gonna use dbms_job to execute a procedure every day, but I don't know if I get the task disabled after I shut down the dbms or if the task I did with dbms_job persists !

    Thanks !

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    As long as parameter value job_queue_processes > 0, the job will execute...
    You shut the database down... If the job is running, it is treated like any other
    user on the database ... shutdown immediate will wait for the current trx to complete before taking the db down... Upon reboot, the job is still in the queue to be run at it's next scheduled run time ... If you don't want it to run,
    you can "BREAK" the job (broken status) or alter system set job_queue_processes=0;


    HTH
    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •