I am trying to set up an Oracle 10 scheduled job containing 2 steps. The first step is to run a stored procedure and the second step is to run an exe program.
I've set the schedule up using Oracle Enterprise Manager. The job starts and runs the first step successfully. However, the second step just sits there...it doesn't say stalled and CPU used (seconds) stays 0.
Any idea what I could be missing why my exe isn't starting to run? Is there a better way to schedule this job?
Thanks for your help.