rongjiangsame
Thanks Jay and Rafael. I got your point. (finally) Now back to square one, here is my actual problem -
Current status - time dependency between jobs
Job one on 2005 - doing some formating through stored procedure, scheduled on 2:30 AM every day
Job two on 2005 - automatically created jobs for snapshot replication scheduled on 3:00 AM every day
Job three on 2000 - doing some complicated calculation after replication scheduled on 3:30 AM every day
Job one failed frequently due to the source file not ready etc. Without the success of Job one, Job two and three execution won't break the database but data is useless. So I was thinking to combine these jobs together and keep retry on job one until success then run the other two. (It helps to rerun job one since the source file usually get ready during the night if not ready by 2:30 AM). Because jobs are scatted on SQL 2000 and 2005 I was thinking to use SSIS package, and also because Job two is automatically created by snapshot replication, I have to use SQL server agent job task...
now besides checking the execution status of the job in SSIS ( I am new to SSIS ), did I miss any easier solution for this problem Thanks for your advice.
Rong