Editing AT.exe

I checked my backup folder this am, expecting to see backups from the weekend, but did not. I checked the Windows event viewer to look for an error message regarding my scheduled job. I found in the System section an error at the time of my scheduled job indicating it was unable to find the file.

Windows Event Viewer Error log

Start|Programs|Administrative Tools|Event Viewer
Or if you prefer the command line:

Command.com - to command line window - eventvwr

This page helped with AT command line functions.

I changed the path to my backupdb.bat file and tested by calling the .bat file from the command line using the scheduler. Specifically, I used this command, which was 2 minutes from the time I was typing the command.

at 09:35 /next c:\automateddbbackups\backupdb.bat

This command would execute just once, at the next time indicated. I checked my folder at 9:35 and watched the file being created.

I deleted the job created last week and created a new job, using the command from my test execution at 09:35.

Moral of the story?

Check you syntax and know how to edit and test command line jobs.