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

Offline-Jobs schedule Expand / Collapse
Author
Message
Posted Monday, April 7, 2014 1:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 7:02 AM
Points: 6, Visits: 19
I have scheduled my jobs successfully and they run fine in SQL Server Agent 2008. But When I shutdown my system or close SSMS and the Agent, the jobs fail. Is there any way to make the SSIS Jobs run when SQL Server Agent is offline or when the System is shutdown.

Here SQL Server is installed on my local machine which itself acts like a server. Thanks in advance.
Post #1559234
Posted Monday, April 7, 2014 10:51 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
You are asking to do computing on shutdown machine. It is not possible. To do any process your database should up and accessible. Now if you do have job it will not execute unless and untill SQL Server Agent is running. So that option is also ruled out.

I am still trying to understand what you are trying to achive?


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1559360
Posted Tuesday, April 8, 2014 12:35 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 300, Visits: 810
concur, not possible, what is your goal?

Post #1559651
Posted Tuesday, April 8, 2014 2:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 7:02 AM
Points: 6, Visits: 19
Just wanted to know if SQL Server Agent can run in standby mode.
Post #1559703
Posted Wednesday, April 9, 2014 12:18 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:14 AM
Points: 4,977, Visits: 11,669
ssis2008r2 (4/8/2014)
Just wanted to know if SQL Server Agent can run in standby mode.


You mean while the computer is powered down? As far as I know, pretty much nothing at all can run.

You might like to take a look here if you are in the mood for writing some code to wake it up for you.



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 #1559797
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse