Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 xp_sendmail

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-05 : 21:33:00
Don writes "I was using xp_sendmail for a variety of notification task by using jobs and scheduling them to run database queries and e-mail me the results. All of the sudden it stopped working.

I've been trying for 2 months to try to determine why.

Heres some facts that may help you.

I'm also running backups schedules as jobs.
The database backups are using the notification feature
built into the jobs and I'm getting notification using that feature.

Outlook works fine and CDONT's works fine.

When I use the Query Analyzer with this ---> xp_sendmail 'lefiks@yahoo.com' 'test' it just freezes.

I also have another SQL7 server that I use as a development server and this features still works fine.

As far as I know all the original configurations are the same as before it stopped working.

Needless to say after 2 months of research and banging my head against the wall I'm desperate for help.

Don Lefik
lefiks@yahoo.com"
   

- Advertisement -