April 21, 2009 at 3:33 am
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
April 21, 2009 at 7:32 am
Who did you buy PGP from? Can they provide support? I have used "GPG" in the past for this sort of thing and have never encountered a problem. GPG is from the Gnu project and is compatible with PGP.
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply