September 30, 2013 at 8:33 pm
Hi Guys,
I have Virtual Machine that I installed SQL Dev Edition. Here I need SQL Agent So I can Schedule my SSIS Packages.
Please correct me if I am wrong. FYI I am talking VM (Virtual Machine) not a Server. If my VM on sleep mode or I log off, my schedule
is not gonna run or If I loged off or VM is in Sleep Mood Agent is running find as per Schedule time, is it true?
If not, then how i can use this VM for what mention above? any thought or advise would be really appreciated.
Thanks.
September 30, 2013 at 9:35 pm
SQL Server Agent runs as a service and does not need you to be logged on for it do it's stuff. If you are logged off, that will not affect SQL Server Agent - it will continue running and your scheduled jobs will be run.
However, if the machine (virtual or physical) is sleeping, nothing is going to happen. So, for you this is not desirable.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply