do yourself a favor avoid using SQL Mail, this is just a suggestion
SQL Mail has lots of bug and issues with OL 2K, 2K3 exchange etc.
Use somkethign like this
@From = 'DBServer@mycompany.com'
, @To = 'DBA@mycompany.com'
, @Subject = 'Job Failed!'
, @Body = 'Job Failed. Cover Page is missing on TPS reports'
you can do the same for success
all you have to do is to create your sp_send_cdosysmail procedure
check this articles out
Hope it helps