SQL job showing failed even after doing its job

Question

SQL job showing failed even after doing its job.

The sql job is doing its job however at the end shows failure.
Getting below message in error logs.

Date 9/10/2024 8:57:21 AM

Log Job History (ABC)

Step ID

Server 123

Job Name ABC

Step Name

Duration 00:08:09

Sql Severity 0

Sql Message ID 0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted 0

Message

The job failed. The Job was invoked by User USERABC. The last step to run was step 1 (Backup

---

Event log shows :
SQL Server Scheduled Job 'ABC' (0x56CE429133EEA041958FAF95A3295E28) - Status: Failed - Invoked on: 2024-09-10 08:57:21 - Message: The job failed. The Job was invoked by User USERABC. The last step to run was step 1 (Backup).

---

---

---

---

---

---

---

---

Answer 1

Hi @PUSHPENDER PATWAL ,

Thank you for your reaching out and welcome to Microsoft Q&A!

Could you please look at the output for the job step to help us identifying actual error?

Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

https://docs.microsoft.com/en-us/answers/support/email-notifications

Answer 2

Did you also look at the output for the job step? It is here you will find the error message.