Job notification problems
-
Job notifications work perfectly for jobs created by hands. Not for jobs created by SQL Server.
I've created notification 'when failed' in the distribution agent job - it doesn't work.
Question: how to notificate operator when distribution agent failed?
Comments: The same happens within the jobs created by DB Maintenance plan. If you add any notification into jobs - these notifications do not work. It seems, DB Maintenance plan notification override job notification even if maintenance notification is empty.
(SQL Server 2k + sp3a)
Thanks
-
This was removed by the editor as SPAM
-
Did you check to make sure your mail session was set up correctly in the SQL Agent? (right click on agent, go to properties, it's on the general tab). Also, check under Support Services, right click on SQL Mail, go to properties and click the test button. It'll do a Mapi test and tell you if SQL mail is working correctly. If all that looks ok, I'd check the way your e-mail is set up. I am assuming you're using Outlook? You may need your Outlook configured differently, make sure it's running under the same account that your SQL Agent is.
-
Mail settings are all right, I've checked it.
I use MS Outlook.
A mail works in all cases except the manually added notification in the jobs created by sql server - db maintenance plan and replications. The problem is I need only "when failed" notifications for DB Maintenance plans but they can only send full report.
It seems the DB maintenance plan notification system stops all the other even it is empty
-
The maintenace plan that you have created, must have created jobs in sql agent. can you verify, by looking in to the properties->notification, if any operator has been selected.
-
Sure it has - it's added manually into jobs generated by DB Maintenance plan, not within DB Maintenance plan itself.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply