Home > Archive > MS SQL Server > January 2006 > Can I specify a mail server when running a job in SQL server









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Can I specify a mail server when running a job in SQL server
sweetpotatop@yahoo.com

2006-01-30, 8:23 pm

Hi,

We used to have an email profile in a SQL server, and we can use the
stored procedure..xp_readmail to read email. Now we need to move all
DBs to a SQL server and we are not going to install MS Outlook.

Is there a way I can still read email from a profile, like specifying
the mail server and account? Or is there any alternative?

Thanks in advance. Your advice would be greatly appreciated.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com