Jobs successful, but not actually

Question

I have several jobs that run on a variety of recurring schedules. Recently however, I have a few of them that the result is "Successful" but they produce no result. The jobs send the results through email although I don't think that is important since if I run the job either in a query window, or just right clicking the job and running it its works fine. It just will not run on schedule. Several other scheduled jobs do run fine. Both the job and the schedule are enabled.

Answer 1

Its a regular issue or happen on adhoc basis.

There may be a case server is busy or some other issue. Check SQL server error log & SQL agent log for nearest timesstamp.

---

Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answerand Vote as Helpfulon posts that help you. This can be beneficial to other community members reading the thread.

Answer 2

Is this the only job that sends email ? its possible that the email got queued so the job completed successfully, but the queued email never got sent . As Rohit suggested, please do take a look at the server error logs, sql error logs, sql agent log and database mail logs

---

Sanil Mhatre | Database Developer | MCTS | If you find my reply useful in any way, please vote it as helpful. If it has helped answer your question, please mark it as Answer. http://sqlwithsanil.com