Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

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 Comments1 Solution3554 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
Avatar of donhannam
donhannamFlag of New Zealand image

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

Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answers