| Author |
Topic |
|
gdo
Starting Member
6 Posts |
 Posted - 2002-07-17 : 11:38:34
|
| Could not find stored procedure 'xp_sendmail'. [SQLSTATE 42000]Using: W2K and SQL Server 2000 and my db is 'bdRH'How can I access the 'xp_sendmail' extended stored pdrocedure? I know it is within the master db's extended stored procs.I tried stuff like EXEC xp_sendmail ..... EXEC [dbo].xp_sendmail ..... EXEC [master].xp_sendmail ..... EXEC [dbo].[master].xp_sendmail ..... EXEC [dbo].[master].[Extended Stored Procedures].xp_sendmail ..... But always the same error... ???<Could not find stored procedure 'xp_sendmail'. [SQLSTATE 42000]>Please does anyone know the way to do it?gdo |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-17 : 11:39:43
|
| Hehehehe, soooooo close:EXEC master.dbo.xp_sendmail |
 |
|
|
gdo
Starting Member
6 Posts |
Posted - 2002-07-17 : 11:42:57
|
quote:
Hehehehe, soooooo close:EXEC master.dbo.xp_sendmail
Thanks for your help.At least now I've got a new error...Msg 18025, Sev 16: xp_sendmail: failed with mail error 0x80070005 [SQLSTATE 42000]gdo. |
|
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-07-17 : 11:45:35
|
| Off the top of me head.. that looks like something wrong with your sql agent config... If you need more help, post the syntax your using to send mail.-----------------------Take my advice, I dare ya |
|
|
|
gdo
Starting Member
6 Posts |
Posted - 2002-07-17 : 12:00:55
|
| well it's a job where I make a few queries then I send a late notice through email when required...EXEC [master].[dbo].xp_sendmail @recipients 'someaddress@domain.com', @message = 'Employee #xxxx .......',@subject = 'Late Notice'The job works well when this part is commented out.Any ideas?gdo |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-17 : 12:13:35
|
| Are you sure the mail service is started? Do you run an xp_startmail before xp_sendmail?Technically, I know that xp_sendmail will do (is supposed to do) an xp_startmail if it isn't already started, but... |
|
|
|
gdo
Starting Member
6 Posts |
Posted - 2002-07-17 : 12:15:13
|
| Yes it started |
|
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-07-17 : 13:57:42
|
Try just running that in a query window... See if that gives an errorquote:
EXEC [master].[dbo].xp_sendmail @recipients 'someaddress@domain.com', @message = 'Employee #xxxx .......', @subject = 'Late Notice'
-----------------------Take my advice, I dare ya |
|
|
|
gdo
Starting Member
6 Posts |
Posted - 2002-07-17 : 14:16:28
|
| same error |
|
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-07-17 : 16:18:18
|
| Well, that means it ain't a problem with your job. Couple things to check... Firstly, your SQLmail configuration. Have you successfully sent off a test mail? Is the sql agent service running and if it is.. in what account/permmissions does it have?-----------------------Take my advice, I dare ya |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-17 : 16:47:59
|
| If you are using Exchange 2000 have a look at [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q293422[/url]Also some useful KB articles[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321183[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q311231[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281293[/url][url]http://support.microsoft.com/servicedesks/webcasts/wc091301/wcblurb091301.asp[/url]HTHJasper Smith |
|
|
|
gdo
Starting Member
6 Posts |
Posted - 2002-07-17 : 17:19:44
|
| Thanks |
|
|
|
|
Could not find stored procedure 'xp_sendmail'. [SQ