DB Maint SMTP Alerter

Last Post 14 Jun 2006 08:42 AM by dbandee. 5 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
LostFromTheStart
New Member
New Member

--
27 May 2005 12:04 PM
Does anyone have any experience getting DB Maint SMTP Alerter working?

We have followed the instructions from the product and :

We created the operators and disabled them.
We created the alerts
Assigned the operators to the alerts
We checked the email column and added the email address for the operator
We installed and tested the xp_smtp_sendmail from SQLDEV.net and it worked
We ran the DbMalerterClient.exe to create the tables, configure the service and tested it. ( it sent an email )
We created a job to run every one min in SQL server.... The only step in the job is
xp_cmdshell 'G:\Downloads\DbMaintAlerter\DbMaintAlerter2\Export\DbMAlerterServer.exe dunsqle01\main'
( we are using a named instance )
.Net framework is installed ( we are not sure if it is running )


Does anyone have any suggestions? There are two of us working on this for the past 3 days and can not get SQL to send an alert via email. We can get the alerts to send an email if we execute a job.

LostFromTheStart
New Member
New Member

--
31 May 2005 09:23 AM
Yes I know.... I need to send emails and alerts using lotus notes... My company will not use outlook or exchange..... I've looked on the internet for a solution and found discussions about SQL Alterter.

Now does anyone have any experiance with this tool? Can anyone tell me how to send alerts and mail using Lotus Notes?
LostFromTheStart
New Member
New Member

--
07 Dec 2005 03:45 AM
Hi,
Just saw you post...

I was never really able to get it to work.

If ANYBODY has ever gottend it to work can you please share with the rest of the group?

Thanks
sqladmin
New Member
New Member

--
27 Apr 2006 05:53 AM
try checking out this: xp_smtp_sendmail
by the way this xp uses the following .dll
xpsmtp80.dll

it's an extended stored procedure that you may want to look into.

here is a script i built using xp_smtp_sendmail
http://sqlforums.windowsitpro.com/w...ification+


and... if you need to create the extended stored procedure, and you happen to also have the .dll
here is the code for ya.

----------------------------------------------------------------------
----Create Extended Stored Procedure xp_smtp_sendmail
----------------------------------------------------------------------

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

exec sp_addextendedproc N'xp_smtp_sendmail', N'xpsmtp80.dll'
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

----------------------------------------------------------------------
----------------------------------------------------------------------

hope this is useful.

cheers
dbandee
New Member
New Member

--
14 Jun 2006 08:42 AM
use cdo_sys_mail
LostFromTheStart
New Member
New Member

--
18 Aug 2006 08:52 AM
What is cdo_sys_mail?


Acceptable Use Policy
---