troubleshooting Question

Issue running access with scheduled task on Server 2008

Avatar of donhannam
donhannamFlag for New Zealand asked on
Microsoft AccessWindows Server 2008
2 Comments2 Solutions3554 ViewsLast Modified:
I am tying to run an access ade program that handles some maintance tasks and sends out an email nightly using schedules tasks.
Not an issue doing this on 2003 but in the case:-
1. Server 2008 scheduled tasks does not like gaps http://support.microsoft.com/kb/951246
2. The server is set up with several virtual servers - There is a server for files (main SBS) and a seperate virtual server as I understand it on the same machine for terminal services connections. This is the one I am running the program on as it has MS access installed on it.

I have set the schedules task up using terminal services "Server".

I want to run:-
"C:\Program Files (x86)\Microsoft Office\Office12\MSACCESS.exe" "C:\ProgramData\AutoJob.ade" /cmd "Auto"

This does not work directly on Server 2008 scheduled tasks because of gaps.

Therefore I have set up a bat file as follows:-
"C:\Program Files (x86)\Microsoft Office\Office12\MSACCESS.exe" "C:\ProgramData\AutoJob.ade" /cmd "Auto"

I then just have the following command in the scheduled task:-
C:\ProgramData\Auto.bat (no double quotes)

If I right click on task and run it runs fine. If I schedule and log off it does not complete the task - the history shows it starts the task and gets to the posistion of "Created Task Process" But does not complete - terminates an hour later.

If I schedule to run while I am still logged on I get - as Task Start failed error with the following message:-
Task Scheduler failed to start "\Auto" task for user "SBS\administrator". Additional Data: Error Value: 2147750687

On the task it has "Run only when user logged on" - When this is ticked I can run OK by right clicking. If I tick "Run whether user logged on or not" I cannot run by right clicking and run - starts and does not complete.

I have tried scheduling the task with this turned on and off and with the "Do not store password on or off and hidden but all have same result.

Appreciate any ideas.
ASKER CERTIFIED SOLUTION
donhannam

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros