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.




1 comment:


  1. From: Bhavesh Thakkar [mailto:***@***.com]
    Sent: Thursday, October 25, 2012 15:31
    To: ****@******.com
    Subject: SQL Server Job System: 'Set Automatic Criteria For ******' completed on \\ServerName\InstanceName

    JOB RUN: 'Set Automatic Criteria For *******' was run on 10/25/2012 at 3:30:00 PM
    DURATION: 0 hours, 0 minutes, 31 seconds
    STATUS: Succeeded
    MESSAGES: The job succeeded. The Job was invoked by Schedule 9 (Schedule for Job Set Automatic Criteria). The last step to run was step 1 (Steps for automatic criteria).

    ReplyDelete

Dear User,

Thank you very much for your kind response