0

I have a SQL Server Job which has some steps include execution of store procedures. The job ran successfully. However, some steps which executes store procedure did not run fully as per my understanding. The message is

The statement has been terminated. Message 3621. The step succeeded.

enter image description here

The highlighted steps should run longer than in the screen shot. Because these stored procedures include insertion of millions of rows into destination table. It works perfectly fine when I run these stored procedures from SSMS. I don't understand why this is happening from SQL Server Job Agent?

I have configured the job if any step fails it will quit the job. enter image description here

enter image description here

Jay Desai
  • 821
  • 3
  • 15
  • 42
  • For each step you can choose what to do on success and what to do on failure and the choices are the same for both. So you can for example on the Advanced page choose to "Quit the job reporting success." as the On Failure action and "Quit the job reporting failure.' as the On Success option if you really want to confuse people. – Brian May 25 '20 at 19:57
  • @Brian, Job has been configured like that only. – Jay Desai May 25 '20 at 19:58
  • Show the Advanced page of the job step properties of one of the steps in question. – Brian May 25 '20 at 19:59
  • 1
    You will also have to show the script for the text. Its quite easy to have a statement fail, but the step pass, such as if the fail has been caught inside the sctript. – TomC May 26 '20 at 06:10

0 Answers0