I have a job on server a which does a backup and copy to server B runs at 7. If the job works I want it to restore on server B. This is a job on serer B. I have the tsql to check if the job on server A worked. If I put this sql in job step 1, is there a way to tell the job to exit and not go to step 2 (which is the restore and a few other steps)
I've done something similar in the past by just setting a flag on a table, and then putting the entire code into an If statement - if the flag is true, then perform all steps inside. If the flag isn't true, then no sql gets executed.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply