My exchange server will be down this weekend. I’ve managed to disable all emails notifications for jobs (in msdb | sysjobs | notify_level_email = 0) but am wondering about all the stored procs and DTS packages that call xp_sendmail.
The concern is that if the database can’t find the exchange server then the SQL Agent might shutdown or restart. This has been the case in the past (pre-SP4).
Any comments would be helpful – else, it’s going to be quite a manual process!