Does this only run if the job fails? Can you make this run when jobs also complete? On our 2005 machines

we have all jobs will email on failure except the user databases we have email upon completion.

I am also not sure about this,

exec SQL_Server_2005.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'

--------------------------------------------------------------

Profile name is the name of the account with no @companyemail.com at the end.

Is that also reentered in the @recipients only with the @companyemail.com at the end?

I am assuming that we don't have to use copy_recipients if we don't want, that is optional?

Any help is appreciated.