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.
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.
