?
Solved

Issue running access with scheduled task on Server 2008

Posted on 2010-03-29
2
Medium Priority
?
3,223 Views
Last Modified: 2013-11-29
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.
0
Comment
Question by:donhannam
2 Comments
 
LVL 59

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 29096311
<<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
 

Accepted Solution

by:
donhannam earned 0 total points
ID: 29830389
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month4 days, 14 hours left to enroll

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question