Discussion Locked

Scheduling a job in AT

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to schedule a job in AT, and AT won't run the job. The job is opening an Access database. I have the job in a batch file and the batch file runs fine when run at the DOS prompt. I can schedule the job to run in AT, but when the scheduledtime comes around , nothing happens in AT. I have tried this on both an NT server and an NT workstation. Neither one will run it. I do have other jobs running in AT and they run fine. I've checked the "LOG in AS" on the scheduler service, but it won't let me change it. It is set to log on as system account. Any suggestions?

7 replies

by rabbit_runner

Hi, I believe your problem is with permissions. When the batch file is run manually, permissions are from the currently logged in user. But when the AT runs the batch file, it is the 'system' user. 'System' probably does not have permissions to run the program that the batch file is attempting to open. Check that out.

by gperrie

If you need to run the batch file as a different user, install IE5 or greater and check the option for the offline browsing pack

This installs the task scheduler which will replace the AT command with a nice new GUI version that also lets you specify a user account to run as.

It will also upgrade all current AT jobs to task scheduler jobs allowing you to view them all in the one place

Once it is installed, you should see the folder in My Computer or Explorer called Scheduled Tasks, i think

Gavin

by don christner

Unless you are scheduling an EXE filetype, you must specifically load cmd.exe. For example, if your batch filename is runme.bat, your AT command would be:

cmd /c runme.bat

Use other options to schedule when and how often to run.

Don

This discussion is closed to new replies.