No Outlook on Server - How to Send Job Email Alerts?

[smedvid]

My databases are being transitioned to a data center in anotehr state, and I was just informed that Outlook will not be installed on any servers. I have aksed the DBA Team how they will monitor jobs and they referenced a third party product. Which is fine, however, I have email alerts for users on Job Completion via SQL Mail through MS Outlook. What options do I have? Create an SP that uses SMTP Mail with the CDO Library, and add a step to the jobs? Any other options?

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[SQLDenis]

take a look at xp_SMTPSendMail (

http://www.thorpesoftware.com/readme.htm)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLSister]

Frankly, I would tell them that they have to convert your jobs to send you the alerts you need.

You could write an active_x task and add it to the job as a step or you could write an extended stored proc to do them same thing and addit to the job. Or what you said.

Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[smedvid]

Thanks, but... purchasing and getting the DBA team to approve installation, could be a problem.


Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[SQLDenis]

Still cheaper than Outlook (Single Server Licence $70 )
and a lot less work, find and replace xp_sendmail with xp_smtpsendmail
Or you can do the things that SQLSister suggested



Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[vongrunt]

> Thanks, but... purchasing and getting the DBA team to approve installation, could be a problem.

OK then, suggest 'em Fedex, DHL, Pony Express... .

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[SQLSister]

I still say, they are breaking your system, it's up to them to come up with the fix. Make sure that your boss is aware of the issue as well. Ask him or her to escalate the issue to their boss to get them to fix the problem they created.

Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[adamroof]

Cant you use Profman? No need for outlook

http://support.microsoft.com/?kbid=228736

You setup the mapi info, then connect to it using the SQL Mail Agent. (sql services need to be started under domain accounts)

I have never had outlook on servers. Not good practice, especially on 2003 server boxes

If you have an off version of mapi32.dll, you will not have the option under agent properties(grayed out), then you need SQL 2000 SP4.

http://www.microsoft.com/downloads/...446-99A9-B7F0213F8BC5&displaylang=en#filelist

If you have SQL 2k5, then use database mail instead.
Hopefully we can all use smtp instead of mapi real soon.

 

[smedvid]

Thanks, I will investigate the mapi32.dll option...

Steve Medvid
&quot;IT Consultant & Web Master&quot;

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...