Using DBMS_SCHEDULER to execute a three step job of different type(2 stored procedure and an executable)

Hi Guys,

I would like to schedule 3 jobs which should run one after the other. The first job is a procedure which when successfully completed should invoke a executable from the operating system and once that finishes successfully , which can be determined by a return value should invoke another stored procedure. How can this be accomplished?

your inputs are highly aprreciated.

Thanks Received on Tue Jul 17 2007 - 13:34:31 CDT