Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a SQL Server Agent job that fails every once and a while. This has become a problem because I recently upgraded to windows 7, and so I no longer get the notifications for the failures.

The computer doesn't have outlook installed on it, so I can't set it up to send email notifications until I figure that part out. I'm hoping someone knows a trick to make the netsend notifications work when routed to a computer with windows 7.

share|improve this question
add comment

migrated from stackoverflow.com Mar 2 '11 at 18:28

This question came from our site for professional and enthusiast programmers.

4 Answers

up vote 1 down vote accepted

I believe the net send and pager notifications are scheduled to be deprecated from future versions of SQl Server.

http://msdn.microsoft.com/en-us/library/ms143729.aspx

It would be wise to get database mail setup. It uses Service broker and CDO and no longer require outlook MAPI profile to be configured,

http://msdn.microsoft.com/en-us/library/ms175887.aspx

share|improve this answer
add comment

You could try xpsmtp which was put together to allow prehistoric SQL Server versions to send SMTP emails. The last 3 releases of SQL Server have SMTP mail built in of course...

share|improve this answer
    
I've got something like this already, where I put an extra step at the end of the job that all failures point to (on failure go to step 5) which would notify me of the error. The downside to this is that it would always show an error on step 5, so I would never know which step was the original failure point. Know of a way to more seamlessly integrate this into the notification system? –  AndyD273 Mar 2 '11 at 20:30
    
Frankly, upgrade... you have no local MAPI client for SQL agent mail and net send is blocked in later OS. Bummer. Your options are very limited... –  gbn Mar 2 '11 at 20:31
    
Upgrading is possible. it's something that we've talked about doing. Do the newer versions of SQL Server have better ways of doing this? We are really having a hard time getting outlook installed on that machine for some reason. –  AndyD273 Mar 8 '11 at 15:32
1  
@AndyD273: yes, SQL Server 2005 has built in SMTP support. msdn.microsoft.com/en-us/library/ms175887%28SQL.90%29.aspx No MAPI needed –  gbn Mar 8 '11 at 15:36
add comment

i don't think you can net send to other computers anymore. not since like windows xp.

share|improve this answer
add comment

Check this out:

http://www.petri.co.il/msg-exe-net-send-vista.htm

You can't use net send after Windows XP.

share|improve this answer
    
Can this be integrated into the notification system? I'm working on getting the normal SQL Mail working, but in the mean time it would be nice to have something like this working. –  AndyD273 Mar 2 '11 at 20:30
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.