Issue running access with scheduled task on Server 2008

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.
donhannamAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Appreciate any ideas.>>
Did you ask this question before?  Sounds identical to another one.
In any case, if the app interacts with the desktop in any way, it's not going to run unless your logged in.  When logged off, a desktop is not available.
 Have any changes been made to the application since it ran under 2003?
JimD.
0
donhannamAuthor Commented:
Thanks for comments - I was hoping someone had had the same issue and may be able to point me in the right direction. I have not logged this one before and could not find any related ones on searchin through EE. No changes have been made to the app - I am pretty sure it is a 2008 server issue or permissions issue.

We have got around this issue by setting up a virtual PC with windows XP on the server and using this to schedule the jobs which is working OK so problem is solved for us but not ideal.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.