I tried running this script on SQL2005, then using the output to recreate scripts on SQL2005. I then compared your output with the output generated by running the "generate script" in SSMC. A few differences arise. Can you tell me if it is due to running output in SQL2005 rather than on SQL2008? Perhaps the differences address "bugs/improvements" that are corrected in SQL2008?
#1 Error checking line is not included after each step in a job.
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
#2 In call to sp_add_jobschedule, your script passes the schedule_uid, where the SSMC does not.
Can anyone comment ? Amit?
Excellent tool - thank you !!!