Thursday, October 25, 2012

Database Experts:How to Set SQL Server 2005/2008R2 Alerts

How to Setup SQL Server 2005/2008R2 Alerts


Sometime we need some alerts on mail or any other message service regarding SQL Server Database.
Alerts including Database running jobs,sql server performance etc...

For this purpose,SQL Server Provide features of alerts in SQL Server Agent.



Follow the steps.

1.Go to SQL Server Agent into SSMS.

Go to Properties by right click on it.





2. Select Alert System





Enable Mail Profile.




3.Go to Operator inside SQL Serve Agent.

Right click on it  for New Operator.



Fill the Information.



4.Create an Alert.

Right Click on it to create new alert.





Fill the Information.



Go to Response.

Choose Operator for notification.



Go to Options.

Select Alert method by Email,Pager or Net Send.




5.Check mail when event occur.