April 7, 2014 at 1:04 pm
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.
April 7, 2014 at 10:51 pm
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."
April 8, 2014 at 12:35 pm
concur, not possible, what is your goal?
April 8, 2014 at 2:31 pm
Just wanted to know if SQL Server Agent can run in standby mode.
April 9, 2014 at 12:18 am
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.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply