• I've also implemented a few job chains and that is one of the features that I really liked in SQL Sentry's EM. Basically, we wanted to run some tasks in parallel after one task finished. So we used the job chain to link them together, execute a group of jobs after one finishes and then execute a final step after all 3 of the parallel tasks finished. These were all on the same server, but I believe you can schedule across servers and even toss control between SQL Server and Windows Task Scheduler jobs.

    __________________________________________________

    Mike Walsh
    SQL Server DBA
    Blog - www.straightpathsql.com/blog |Twitter