January 22, 2008 at 12:05 pm
Hello,
We run this job everyday, and it is not running successfully, below is the error message I am getting,
The job failed. The Job was invoked by Schedule 42 (DTS_WAYBILL_FROM_AS400_TO_ICSTNTX). The last step to run was step 1 (DTS_WAYBILL_FROM_AS400_TO_ICSTNTX). NOTE: Failed to notify 'HELPDESK' via email.
I would appreciate if someone can assist me on this,
Thanks,
Dev
January 22, 2008 at 1:07 pm
I assume your dts package (dts2000 ?) is trying to send a mail, but it does not succeed. Hence "NOTE: Failed to notify 'HELPDESK' via email."
Check your account that serves the job has the rights to the mailbox,...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 22, 2008 at 1:24 pm
Did you have any luck determining the data error causing the DTS package to fail?
I know that would solve your e-mail issue, but then again - you wouldn't NEED to send an e-mail if the DTS package finished correctly.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
January 22, 2008 at 8:56 pm
Two suggestions.
1. Check you mail server and email address
2. Add a log file in your DTS package to obtain error in detail.
January 22, 2008 at 9:23 pm
if possible try to run the DTS independent of a scheduled job in test environment.
or it could be that your exchange or mail is not setup properly in SQL 2005 if email is the last step in your DTS package.
January 22, 2008 at 9:33 pm
Run DTS independently you can know where it is failing.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply