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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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