I have a Stored Procedure that I can execute from SQL Mgmt>New Query and running the exec statement and all is well. However, I have the same statement in a automated SQL Agent Job that the first step creates the Stored Procedure, second step executes
Stored Procedure and then various other steps afterward. However, the job worked fine for a while and now the job dies at the second step each time. If I copy and paste the command for the second job in a new query manually, it works fine and the rest of the
steps can process. Is this a bug?
View Complete Post