Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

migrated from Mar 2 '11 at 18:28

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

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.

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,

share|improve this answer

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
@AndyD273: yes, SQL Server 2005 has built in SMTP support. No MAPI needed – gbn Mar 8 '11 at 15:36

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

share|improve this answer

Check this out:

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

Your Answer


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.