We have Scheduled Job which does produces XML file, then uses PGP to encrypt the files before FTPing.
Now, when ever the PGP fails it crashes the SQL Agent partially. What I mean by partially is that all the jobs which uses BAT/CMD files (directly or indirectly via DTS/SSIS packages or EXE ) runs fines without actually executing the commands in BAT/CMD files, execution time for those steps is 0 sec, whereas all T-SQL jobs works fine. For all those steps and BAT file logs are also empty since nothing was executed.
The problem is resolved by restarting the Agent.
What could be the reason for the corruption of the Command Shell of SQL agent?
Cheers