question

samnick-7321 avatar image
0 Votes"
samnick-7321 asked Monalv-msft edited

SQL Agent job in Executing state even after failure

Hi ,
I have a SQL agent job setup which is set to quit upon Job failure.

![70230-image.png][1]



Now oddly, even when the job fails - I confirmed this from Integration Services Catalog > Job Name > All Reports ., the actual job from within the SQL agent stays in Executing state. This is preventing further re-runs of the schedule. I have restarted the server (VM) , and it resolves for that instant. But the issues comes back again during next failure.

Any recommendation on why this is happening and what is the resolution.

sql-server-integration-services
image.png (65.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @samnick-7321 ,

Please set Retry attempts as 0 and Retry interval(minutes) as 0 in Job Step Properties if you want to quit upon Job failure.

70390-job-step-properties.png

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.








5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

samnick-7321 avatar image
0 Votes"
samnick-7321 answered Monalv-msft commented

I made the change as per your recommendation, but the Job still shows as Executing in the Job Monitor even though the Services Catalog shows a failure. I have to manually terminate the job from the Job monitor.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @samnick-7321 ,

Could you please share the error messages after executing the job?

Best Regards,
Mona

0 Votes 0 ·