dbms_job submission with condition
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dbms_job submission with condition

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182

    Question

    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
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I would create a wrapper script that called your procedures in order. If an exception is encountered, send mail to your pager.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    Will you please send me some details or url for wrapper

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