Hello, coming across a strange behavior in that I successfully created a SQL Agent job as:

DECLARE @body_message nvarchar(max) = 'Message body here for Line 1.' + CHAR(13) + CHAR(10) + 'Message body here for Line 2.'

EXEC msdb.dbo.sp_send_dbmail @profile_name='SQLProfileName',
@recipients = 'RecipientEmail@hotmail.com',
@body = @body_message,
@subject = 'Subject Here.'

But when using the same exact above coding as a template model for another job on same SQL Agent server it keeps the @body as 1 line only instead of 2 separate lines which is what I'm aiming to do.

Is there a setting within a SQL Agent job that needs to be adjusted in explaining this inconsistent behavior?

Thanks in advance.

Guess never mind as it's working now in that odd the 2nd job @body_message didn't have a '.' (period symbol) at the end of it's string sentence which when simply adding period symbol it looks like it now work.

Thanks anyways.