I have this:
@profile_name = 'DBA_Mail',
@recipients = 'firstname.lastname@example.org',
@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..
DBA, Project Manager, Big Data Enthusiast