Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««34567

How to use Database mail feature in SQL Server 2000 Expand / Collapse
Author
Message
Posted Friday, November 11, 2011 6:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:21 PM
Points: 2,270, Visits: 3,780
I am not quite sure on this one.

Mohammed Moinudheen
Post #1204083
Posted Friday, November 11, 2011 8:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, June 12, 2012 8:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 9, 2014 3:41 AM
Points: 11, Visits: 117
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
Posted Tuesday, June 12, 2012 8:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 24, 2014 12:57 PM
Points: 199, Visits: 1,489
Place [] around the database name.
Post #1314490
Posted Tuesday, June 12, 2012 9:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 9, 2014 3:41 AM
Points: 11, Visits: 117
Thanks for that realised 5 minutes after posting this. all working fine now.

Thanks again.



Post #1314517
« Prev Topic | Next Topic »

Add to briefcase «««34567

Permissions Expand / Collapse