Configure SQL Server Email forwarding and JOB notification notification features

In database-related projects, such as database maintenance, performance alerts, program error alerts, or notifications, you will use the ability to configure email messages in SQL Server.

In a BI project, this functionality is also used more. For example, SSIS Package are typically configured to execute as scheduled by the SQL Server Agent, when Package execution fails to send a mail notification in the JOB to troubleshoot the error in a timely manner. Sometimes at the Package level, the error message is also stored in the wrong log, and a trigger is used to send the message to prevent the Notification from being configured successfully or disabled in the Job.

One based on the table level, one based on the Job level, all of which need to use the basic mail Configuration feature.

Start Configuring mail Services

First time configuring using