I have this:
@profile_name = 'DBA_Mail',
@recipients = 'email@example.com',
@body = 'The count of the unprocessed records.',
@subject ='Number of unprocessed records on SQL1 '+ cast(@recordcount as varchar(10));
somehow the @subject...doesn't like the + sign.
The @recordcount does evaluate itself to proper number.
if I use @subject = @recordcount it works great.
any help is welcome..