Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2013-09-30 : 22:35:04
|
| 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 scheduleis 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
38200 Posts |
Posted - 2013-09-30 : 22:38:30
|
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2013-09-30 : 22:45:13
|
| 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! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-09-30 : 22:59:17
|
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2013-09-30 : 23:01:29
|
| yes good question, due to some security reason or something we can't install, Machine has Window7 with SQL Developer Edition installed. |
|
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2013-10-01 : 04:00:28
|
| go to this path to change the sleep mode?Control Panel\All Control Panel Items\Power Options\Edit Plan Settings |
|
|
|
|
|
|
SQL Agent Help...