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