How to use Database mail feature in SQL Server 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Mohammed Moinudheen... » How to use Database mail feature in SQL...

65 posts, Page 7 of 7

«««3 4 5 6 7

How to use Database mail feature in SQL Server 2000

Rate Topic

Display Mode

Topic Options

Author

Message

mohammed moinudheen

Posted Friday, November 11, 2011 6:39 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582

I am not quite sure on this one.

Mohammed Moinudheen

Post #1204083

danskisanjar

Posted Friday, November 11, 2011 8:16 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 15, 2011 2:01 PM
Points: 8, Visits: 51

That is ok. You have been a big help to me. Thanks!

Post #1204178

CliveW

Posted Tuesday, June 12, 2012 8:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 3:17 AM
Points: 9, Visits: 92

Nice article all set-up and works fine in Query Analyser but fails as a job this is down to the way our servers are named any suggestions on getting round this.

In Query Analyser can use.

exec "res-sql-002".msdb.dbo.sp_send_dbmail
@profile_name = 'SampleSQLServer2005dbmailProfile',
@recipients='yourname@email.com', --@copy_recipients = 'yourgroup@email.com',
@subject='Job test_db_mail failed on SQL Server 2000 server',
@importance='HIGH',
@body ='Job test_db_mail failed on SQL Server 2000 server'

But soon as trying to add within a job will not parse with error around the -sql-

Error 170 line 1 Incorrect syntax near sql

Post #1314485