March 25, 2014 at 11:47 am
What kind of configuration should I be having to make sure all SQL jobs scheduled to run during downtime hours run once the sql server come online again. Configuration for only SQL jobs to run automatically after servers are brought online. Configuration for SQL jobs scheduled to execute SSIS packages automatically once the servers are brought online.
March 25, 2014 at 11:49 am
Why are they being taken off-line?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 25, 2014 at 11:59 am
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.
March 25, 2014 at 1:13 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply