Database Experts

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.