Prerequisites
Before you can run the script to set this up you need to have the customer input their email settings in the SQL Database Mail Configuration Wizard with the email they would like to receive alerts on.
- The setup should look like this when the customer is finished:
The script that creates the alert job.
Run the following script after the prerequisites are done to create the job.
TEST
