Job Notification

On our SQL 2000 server there is no MAPI client or Outlook installed. The NET
SEND command has been disabled on the server/network. The xp_sendmail can n
ot be used due to SQL Mail not started due to no Outlook profile. I don't fi
nd that the Notification pa
ge allows to attach a command or batch file to do this job. It is just writi
ng the Log to Application Event Log. Any feedback would be appreciated.There're about three ways to email a notification for a job:
1. Install MAPI and Outlook to have SQLMAIL work together with Exchange.
2. Install xp_smtp_mail and it's dll to bypass MAPI.
3. Install sp_send_cdosysmail and use this stored procedure to send out
email.
I personally prefer sqlmail due to it's rich features. But be aware of its
total dependency on MS Exchange.
"Fraz" <Fraz@.discussions.microsoft.com> wrote in message
news:55D6ACD2-73BC-46F9-894B-8F1F9F4DC4C2@.microsoft.com...
> On our SQL 2000 server there is no MAPI client or Outlook installed. The
NET SEND command has been disabled on the server/network. The xp_sendmail
can not be used due to SQL Mail not started due to no Outlook profile. I
don't find that the Notification page allows to attach a command or batch
file to do this job. It is just writing the Log to Application Event Log.
Any feedback would be appreciated.|||Hello Richard,
Thanks for your valuable feedback. I looked for xp_smtp_mail and sp_send_cdo
sysmail in the Master database but could find them. Could you please let me
know where I can find these procedures. Thanks...Fraz
"Richard Ding" wrote:

> There're about three ways to email a notification for a job:
> 1. Install MAPI and Outlook to have SQLMAIL work together with Exchange.
> 2. Install xp_smtp_mail and it's dll to bypass MAPI.
> 3. Install sp_send_cdosysmail and use this stored procedure to send out
> email.
> I personally prefer sqlmail due to it's rich features. But be aware of its
> total dependency on MS Exchange.
>
> "Fraz" <Fraz@.discussions.microsoft.com> wrote in message
> news:55D6ACD2-73BC-46F9-894B-8F1F9F4DC4C2@.microsoft.com...
> NET SEND command has been disabled on the server/network. The xp_sendmail
> can not be used due to SQL Mail not started due to no Outlook profile. I
> don't find that the Notification page allows to attach a command or batch
> file to do this job. It is just writing the Log to Application Event Log.
> Any feedback would be appreciated.
>
>|||Hello Richard: Thanks for your feedback. Will appreciate if you could let me
know where I can find xp_smtp_mail and sp_send_cdosysmail procedures. Thank
s...Fraz
"Richard Ding" wrote:

> There're about three ways to email a notification for a job:
> 1. Install MAPI and Outlook to have SQLMAIL work together with Exchange.
> 2. Install xp_smtp_mail and it's dll to bypass MAPI.
> 3. Install sp_send_cdosysmail and use this stored procedure to send out
> email.
> I personally prefer sqlmail due to it's rich features. But be aware of its
> total dependency on MS Exchange.
>
> "Fraz" <Fraz@.discussions.microsoft.com> wrote in message
> news:55D6ACD2-73BC-46F9-894B-8F1F9F4DC4C2@.microsoft.com...
> NET SEND command has been disabled on the server/network. The xp_sendmail
> can not be used due to SQL Mail not started due to no Outlook profile. I
> don't find that the Notification page allows to attach a command or batch
> file to do this job. It is just writing the Log to Application Event Log.
> Any feedback would be appreciated.
>
>|||Below might be useful:
http://www.karaszi.com/SQLServer/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Fraz" <Fraz@.discussions.microsoft.com> wrote in message
news:1858581C-7207-4788-B9D3-5C02874DB8A3@.microsoft.com...
> Hello Richard,
> Thanks for your valuable feedback. I looked for xp_smtp_mail and sp_send_cdosysmai
l in the Master database
but could find them. Could you please let me know where I can find these procedures. Thanks.
.Fraz[vbcol=seagreen]
> "Richard Ding" wrote:
>