smusba
28th December 2011, 09:52
I have defined a job which has 5 sessions (Process & Print Sessions) setup in the Job and it is scheduled to run at 9pm everyday. Now I have a requirement wherein I have another Job which should be executed only after successful execution of the first Job. The second job is setup such that it will run every day at 1am. If the first job gets completed before 1am then still the second job has to schedule at 1 am, but if first job gets completed after 1 am then the second job will be scheduled immediately after that.

Hitesh Shah
28th December 2011, 18:52
Only 2 ways either schedule all the sessions / process in 2nd job in job 1 after 5th session process (using skip on success / error ) or to check in a session in job 2 to check for status of job 1 or check for application lock of job 1 and in case locked , wait till it gets changed.