I have a post-install script that sets up all of my nightly maintenance and backup stuff as well as the alerts, operators, DBMail config, etc.

Considering the number of servers I set up, the time spent on writing the script was well worth the effort. No typos, consistent job names/times/backup locations/etc.

/*

** Script name.....: SQLAgent_SetupMaintenanceSupport.sql

** Blame...........: Ken

** Purpose.........: Automate

** o Enabling Database Mail

** o Creating an email account for DBMail

** o Creating an email profile for DBMail

** o Associating an email account with a profile

** o Making the new profile the default profile

** o Create an operator based on the new profile

** o Sending a test email message

** o Adding a login for the new job owner

** o Creating a full backup job and schedule (with DR scripting)

** o Creating a differential backup job and schedule (both disabled)

** o Creating a transaction log backup job and schedule

**