I have a Job I set up with a number of steps...none of the CmdExec steps seems to work. Something as simple as a copy or delete or whatever...
They worked previously, the next day I re-ran it, and it did not work. It shows successful, no notes as to what happened...the same commands work fine right in a command line.
I thought, since nothing had changed, that maybe a reboot would resolve it...it didn't.
Running SQL 2005 Standard on Win2003.
I am logged in as sysadmin.
The steps functioned perfectly the day before. Nothing changed from then to now.
NO CmdExec steps work...I tried creating a test job with just some simple command lines and they did not run...although the history shows nothing wrong and it passes.
Any assistance would be most appreciated.