August 4, 2006 at 2:27 pm
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!
August 6, 2006 at 9:14 pm
Dear ,
Have u scheduled the job to execute the SP and send email.
If yes then disable the job.
All problem will be solved.
From
Killer
August 7, 2006 at 3:11 pm
I not sure this will be helpful, but if you have SMTP server than see link below. it may be helpfull to email you job failed or Alerts. You need to have SMTP Server to work this XP. I hope this may help you.
http://www.sqldev.net/xp/xpsmtp.htm
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply