• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 492
  • Last Modified:

How do I successfully run a task scheduler on SQL server 2008 when I am not logged on.

I created a task in Windows Task Scheduler which calls a vb script  daily. I am on Windows Server 2008 and have admin privileges.
When I set the option to "run the task only when the user is logged on", the script works correctly.
When I set the task to "run whether user is logged on or not" and with the highest privileges, the script does not work correctly.
The script should create excel files and save them in a specified location.
When running the task whether the user is logged or not, the reports are simply not created.

I have been trying to fix this problem for a week with no luck. Any advice would really help...

Thank you!
0
kmgingee
Asked:
kmgingee
  • 4
  • 2
1 Solution
 
NJComputerNetworksCommented:
what does the status in the task schedule show?
0
 
kmgingeeAuthor Commented:
I am aware that the "tasks will not run interactively". The problem is that the excel files simply do not get created.
The task stays on running mode, until I manually end it.
That only happens when I want it to run "whether the user is logged or not".
Can simply checking that box affect the task in such a way?
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
NJComputerNetworksCommented:
I performed the test.bat file shown in the above link.  It works as expected.  therefore, I think there may be something in your script that is running interactively...

Is is possible to edit you script, and place more logging... for example, write to the log as you move through the script... this will help pin-point where the script is stopping..

Maybe out to a text file vs excel... maybe excel can't be used non-interactively?
0
 
kmgingeeAuthor Commented:
What confuses me is that if I run the task on Windows XP, it works fine.
Is this a windows server 2008 issue?
0
 
NJComputerNetworksCommented:
yes, sure... windows 2008 is different...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now