• sqlserver12345 (3/25/2014)


    Lets say they have to be restarted and those moments when the server is getting restarted is when the SQL jobs are scheduled.Is there a configuration which would take care to make sure all individual SQL jobs and SQL jobs which run SSIS packages run automatically once the server is brought online.

    No they won't run automatically. They will be skipped by the scheduler. You need to invoke them manually.

    --

    SQLBuddy