DBMS_JOB submission
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DBMS_JOB submission

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    hi!
    I have three batch procedure proc_1, proc_2,proc_3
    I want to submit batch jobs in such a way that 2nd job should start after completion of 1st job and 3rd job should start after completion of 2nd.
    Also if any of the job is unsuccess should notify via email.

    Does any body has done this using oracle.
    (not using unix cron job or any scripting...)

    Any help appriciated

  2. #2
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    u can figure out the success or failure of a job by querying the USER_JOBS table. the column FAILURE will give the number of times it has failed. so u can store the value of FAILURE column before executing the procedure and then compare it with the value after executing. if it is same, it can be assumed that the procedure is successfully executed. this is also assuming that successful execution means only from Oracle point of view and not from the application point of view.

    is this what u want?
    Cheers!
    OraKid.

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