Is this always or sometimes ?
We occasionally have problems with notifications but its quite rare
99% of the time it works fine. Could try recycling SQLAgent but
generally if we click on test for SQLAgentMail and it works we tend
to shrug our shoulders and ignore it :) - its only the notification after
not the job thats failing.
Quote:> Scheduling jobs in SQL Server Agent Jobs.
> Backing up the system/user databases works fine but, at
> times the email notification fails. viewing the job
> history gives the following:
> The job succeeded. The Job was invoked by Schedule 1
> (Schedule 1). The last step to run was step 1 (Step 1).
> NOTE: Failed to notify 'Support' via email.
> Thanks in advance for your help!
> Ashley Jno Baptiste