• Hi Ed,

    Thanks for getting back..

    so I followed the blog and it worked fine

    USE msdb

    EXEC sp_start_job @job_name = 'C387D481-5A3D-4DF8-89BC-10A55A5FE1F4'

    But....

    I wanted to run a second step which EXEC an sp which updates a flag in the step1 sp for the report

    The problem is when I add the second step the report is blank, because the second step has updated the flag..

    Is there a way to email the report before the update in step2 or maybe run as two jobs?

    Thanks

    Joe