A batch job that executes once daily is configured to send job completion
notification on success or failure. Usually it works. Twice in the past
week it didn't, and this message is in the Application Log:
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 210
Date: 8/8/2005
Time: 11:10:07 PM
User: N/A
Computer: xxxxxxx (name withheld to protect the guilty)
Description:Unable to send job completion notification email to operator
'DBA - SQLExec' for job 'Maintenance and backup'.
Both before and after the occurence of the problem, I am able to
successfully send mail with a 'test' of the operator 'DBA - SQLExec'.
Our environment is as follows:
SQL Server 2000 SP3a on Windows 2000 Server.
Outlook 2000 on the SQL Server box.
WAN; and the SQL box is geographically remote from the Exchange server.
MS Exchange email system (newly implemented).
Any ideas would be appreciated. Thanks in advance.Hi,
Thanks for your post.
From your descriptions, I understood your SQLAgent intermittently failed to
report the error message that unable to send job completion notification
email to operator 'DBA - SQLExec' for job. If I have misunderstood your
concern, please feel free to point it out.
I have noticed that this issue will not happen all the time and and based
on my knowledge it is most possible that the Exchange server is unavailable
at that time of name resolution the above error will occur. Check logs of
exchange server to go further for this loss of connectivity between the
MAPI client and Exchange server
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Showing posts with label notification. Show all posts
Showing posts with label notification. Show all posts
Friday, March 30, 2012
Friday, February 24, 2012
Integration services notification services
Does anybody know of a notification services using SSIS? Is it SendMail or otherwise? Is there a step-by-step practice on how to create one?Not sure I understand your question? Are you looking to trigger an SSIS package from Notification Services, or are you want to send a notification from the SSIS package?|||I'm hoping it's the later one - send the notification from the SSIS package.|||You can send an email by using the Send Mail Task in SSIS. Is that not what you are looking for?|||
That would possibly the same as DTS! Do you know of any step--by-step article on how to do this in SSIS?
Just out of curiosity, if I were to use SQL Server's Notification services, I'd be make use of SSRS(reporting services) as well, wouldn't I?
|||If you search the forum for "Send Mail", you should find some links. Also, it's really not a very complicated task to use.
I'm not sure why you are tying Notifiation Services to Reporting Services (or Integration Services, for that matter). They are seperate products, and while they can interact with each other, they do it the same way any external application would interact. For example, SSIS can interact with Reporting Services directly by calling the web service to generate reports (just like any other external application).
|||The reason I mentioned reporting services because I read at a MSDN article that Analysis services uses Repoorting server for Notification Services.|||
onamika wrote:
The reason I mentioned reporting services because I read at a MSDN article that Analysis services uses Repoorting server for Notification Services.
Neither of which are related to SSIS though.
From SSIS look at using the Send Mail task, or using a Web Service to handle notifications.|||Frankly, I don't see any SendMail tasks example or how create an example. Maybe it's because I'm faily new to MSDN.|||
http://forums.microsoft.com/MSDN/Search/Search.aspx?words=Send+Mail&localechoice=9&SiteID=1&searchscope=forumscope&ForumID=80
The second result returned has a walkthrough of using a Send Mail Task inside a For..Each loop. I didn't go through the rest, but I'm sure there are more examples.
|||
Frankly, I don't see any SendMail tasks example or how create an example. Maybe it's because I'm faily new to MSDN.
BOL has some information on the Send Mail task inside SSIS.
http://msdn2.microsoft.com/en-us/library/ms142165.aspx|||
The reason I mentioned reporting services because I read at a MSDN article that Analysis services uses Repoorting server for Notification Services.
Perhaps the nomenclature is a problem here. Perhaps it should be "notification services" rather than (the product) "Notification Services".
I'd like to read that MSDN article because if that is what it says then it is lying. Analysis Services does not automatically use Reporting Services for anything. You can deliver reports on top of Analysis Services using Reporting Services - but that is something else entirely.
-Jamie
|||
Frankly, I don't see any SendMail tasks example or how create an example.
Its very very very very simple. Just try it - witha little perseverance you won't need any documentaiton.
Maybe it's because I'm faily new to MSDN.
Not sure what you mean by this. What has MSDN got to do with this? How can you be "new to MDSN"?
-Jamie
|||I'd like to stick to the point - question about "SendMail" please!
Ok, bonus question for you. This is mostly text based mail I see. How can I make this email HTML based?
|||
I'd like to stick to the point - question about "SendMail" please!
Ok, bonus question for you. This is mostly text based mail I see. How can I make this email HTML based?
Drop the Send Mail task in the Control Flow tool box onto the work surface. Double click on it to configure it. From there, I think you should be able to figure out what to put where.
As far as HTML e-mail (WHY? WHY? WHY?), please search this forum for examples. This has been discussed before.
As an aside - HTML is VERY BAD design, in my opinion. HTML should be left to Web servers to display. If I had it my way (and many in the security community) e-mails would be limited to TEXT ONLY. Anyway......... That's my rant for today.
Subscribe to:
Posts (Atom)