SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Agent Help...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tooba
Posting Yak Master

143 Posts

Posted - 09/30/2013 :  22:35:04  Show Profile  Reply with Quote
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.

tkizer
Almighty SQL Goddess

USA
36613 Posts

Posted - 09/30/2013 :  22:38:30  Show Profile  Visit tkizer's Homepage  Reply with Quote
Are you talking a regular desktop operating system? If so, just setup the VM so that it doesn't go into sleep mode. But why not use a server operating system on this VM?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

tooba
Posting Yak Master

143 Posts

Posted - 09/30/2013 :  22:45:13  Show Profile  Reply with Quote
Yes I am talking Desktop operating system,
What do you mean by setup the VM (Virtual Machine)?
Yes Its set up VM, so I can RD(Remote Desktop) to the VM...
How I can change so it doesn't go into sleep mode?
COuld you please explain what do you mean by "Why not use a Server operating system on this VM?

Thank you for your prompt reply!
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36613 Posts

Posted - 09/30/2013 :  22:59:17  Show Profile  Visit tkizer's Homepage  Reply with Quote
Why wasn't the VM installed with Windows 2008 R2/Windows 2012 as the operating system? What is the purpose of the VM?

I'm not a desktop person, but you should be able to find the sleep settings in control panel.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

tooba
Posting Yak Master

143 Posts

Posted - 09/30/2013 :  23:01:29  Show Profile  Reply with Quote
yes good question, due to some security reason or something we can't install, Machine has Window7 with SQL Developer Edition installed.
Go to Top of Page

waterduck
Aged Yak Warrior

Malaysia
961 Posts

Posted - 10/01/2013 :  04:00:28  Show Profile  Reply with Quote
go to this path to change the sleep mode?
Control Panel\All Control Panel Items\Power Options\Edit Plan Settings
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000