Post reply

Send email in a tabular format - last two columns results are combining

  • December 3, 2015 at 10:00 am

    #399418

    Sorry wrong post. Thanks

  • December 3, 2015 at 10:14 am

    #1843840

    Try this?

    DECLARE @xml NVARCHAR(MAX)

    DECLARE @body NVARCHAR(MAX)

    SET @xml = CAST((

    SELECT

    [JobName] AS 'td', '',

    [step_id] AS 'td', '',

    [step_name] AS 'td', '',

    [RunTime] AS 'td', '',

    [RunStatus] AS 'td'

    FROM [JobStatus]

    FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX))

    SET @body ='<html><body><H3>Job Run Status</H3>

    <table border = 1>

    <tr>

    <th> JobName </th>

    <th> step_id </th>

    <th> step_name </th>

    <th> RunTime </th>

    <th> RunStatus </th>

    </tr>'

    SET @body = @body + @xml +'</table></body></html>'

    EXEC msdb.dbo.sp_send_dbmail

    @profile_name = 'testProfile',

    @recipients='ramana3327@yahoo.com',

    @subject = ' jobs run status',

    @body = @body,

    @body_format ='HTML' ;

  • December 3, 2015 at 2:05 pm

    #1843904

    Thank you.

    I miss that ,'' and changed later.

    Here SET @body ='<html><body><H3>All Jobs Run Status</H3>

    what does it do when we use H3?

  • December 3, 2015 at 2:51 pm

    #1843915

    ramana3327 (12/3/2015)

    Thank you.

    I miss that ,'' and changed later.

    Here SET @body ='<html><body><H3>All Jobs Run Status</H3>

    what does it do when we use H3?

    The <H3> tag is standard HTML. It specifies that the text between the tags is formatted as a heading level 3.

    www.wcschools.com has a great tutorial on HTML (and a few other things) if you need a reference.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • December 3, 2015 at 3:51 pm

    #1843932

    Thank you

  • December 7, 2015 at 11:44 am

    #1844471

    Hi,

    Thanks for your replies.

    I am working the similar kind. I am using the same query but just the columns are different.

    In the query there is an end time, which has 'Null' but from the above, I am not getting any null values.

  • December 8, 2015 at 6:29 am

    #1844635

    ramana3327 (12/7/2015)

    Hi,

    Thanks for your replies.

    I am working the similar kind. I am using the same query but just the columns are different.

    In the query there is an end time, which has 'Null' but from the above, I am not getting any null values.

    I'm sorry, but you're going to have to give us something more to go on. You've been around here a while, so you know how this works. See the third link in my signature if you need to.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply