To set the mail profile for SQL Server AgentYou can define operators to be notified in response to an alert. You can assign rotating responsibilities for operator notification by using pagers. For example, if one or more defined alerts occur on Monday, Wednesday, or Friday, Mary is notified. If those alerts occur on Tuesday, Thursday, or Saturday, Joe is notified. If Mary or Joe cannot be notified on the respective day, or if the alert occurs on Sunday, the fail-safe operator is notified.
You notify operators using one or more of these methods:
The SQLServerAgent service uses a mail session that is exclusive to SQL Server Agent activities. If you are using a SQL Mail session for the MSSQLServer service, it is recommended that SQL Server Agent and SQL Server use the same Windows NT domain user account. This allows both mail sessions to use the same mail profile. If SQL Server Agent and SQL Server use separate Windows NT domain user accounts, you must configure a mail profile for each service.
To set the mail profile for SQL Server Agent
To define the response to an alert
