Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS sqlserver configuration Expand / Collapse
Author
Message
Posted Tuesday, March 25, 2014 11:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 5:09 PM
Points: 178, Visits: 579
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.
Post #1554616
Posted Tuesday, March 25, 2014 11:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:22 AM
Points: 5,073, Visits: 11,849
Why are they being taken off-line?


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1554618
Posted Tuesday, March 25, 2014 11:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 5:09 PM
Points: 178, Visits: 579
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.
Post #1554622
Posted Tuesday, March 25, 2014 1:13 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 11, 2014 2:28 PM
Points: 1,194, Visits: 2,219
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
Post #1554655
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse