July 26, 2011 at 11:39 am
Whenever create new sql agent jobs then always write notification in windows event logs if job fails.
How to change and add such default settings?
July 26, 2011 at 12:33 pm
My Computer -->Right click--> Manage-->Systemtools-->Eventviewer-->Application--> Rightclick --> properties-->Filter.
Uncheck what you don't want(Information).
If you are talking about in sql server error log then right click erro lo and click configure to change.
July 26, 2011 at 12:42 pm
Right click on a job -> Properties -> click on Notifications - there will be an option "write to windows application event log". It needs to be selected and there are further options like in your case, you can select "when the job fails" from the drop down menu
July 26, 2011 at 1:29 pm
i know these option. I want default setting like this so every time when create a new job .. those settings are there.
July 26, 2011 at 5:21 pm
I don't know a way to make that a default in the GUI, but if you use a script to create new jobs, you could put that notification option in the script.
Greg
July 27, 2011 at 12:55 am
Even I am not aware about changing the default setting here. Probably, while creating a new job, you can uncheck the option. however, I always like to see SQL Server alerts in event logs too. Is there any reason why you would want to disable this option.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply