December 19, 2007 at 1:44 pm
We are running Notes for email - is there anyway to get SQL MAIL to work with Notes?
If that is not possible, can someone please tell me how to use Net Send for notifications?
I need to set up notifications for our Maintenance Plans and scheduled Jobs
Thank you~!
December 19, 2007 at 1:59 pm
My first disclaimer, I know nothing about Notes, but if you can use Outlook (not Outlook Express) to connect Notes I believe you can use SQLMail.
For SQLMail to worl you have to have MAPI Profile setup on the server for the user SQL Server Agent is running under. Then you can setup SQLMail to use that profile and send and receive mail from it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 19, 2007 at 2:05 pm
Thank you Jack - but we are not running Exchange at all in our shop so I cannot set up an Outlook Client - but I can try and get an Outlook client to work with our Notes Server... I'll give it a try
Any ideas on getting net send to work?
December 19, 2007 at 2:27 pm
Here is a link to a forum where someone has SQLMail working with Notes using MAPI, but has a different problem, so it is possible to use SQLMail.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15912
As far as net send goes, you need to have the Messenger service running on your server and any pc's you want to send the alert to.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 19, 2007 at 6:41 pm
In my previous job, the company used Lotus notes too. I could not use Net send in the job, instead there was a failure email step and successful email step and used xp_smtp_sendmail to send out email.
So in every step, if it failed, it went to failure email, otherwise next step, if it was the last step, then went to successful email step.
January 28, 2008 at 9:11 am
OK.. I'm finally getting around to setting up my notifications on my SQL Server 2000 Instances..
What I did was setup xp_sendmail as a last step in my maintenance plan (on my test box) most of my maintenance plans are only one step (a full backup) so I manually added a step to the maintenance plan and set Step 1 to go to step 2 upon failure. It works GREAT !!!! However, SQL Server does complain a little when I look at the maintenance plan properties about not liking the fact that I manually added a step.
Does anyone see anything inherently wrong with this???????
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply