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.
@profile_name = 'SampleSQLServer2005dbmailProfile',
@email@example.com', --@copy_recipients = 'firstname.lastname@example.org',
@subject='Job test_db_mail failed on SQL Server 2000 server',
@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