I'm not sure this is the correct forum, so feel free to send me elsewhere.
I have a stored procedure that updates a table once a scheduled Reporting Services (2005) report has been emailed. I would like to be able to define a second SQL Agent job to execute the stored procedure that would not run until the report job has completed.
I tried adding a second step to the report job. Turns out, if the report subscription is modified, Reporting Services regenerates the job and the second step is lost.
Is my only recourse to create the second job and schedule it to run at some arbitrary time after the report job? Or is there some way to declare this job dependent upon the completion of the first?
I have a stored procedure that updates a table once a scheduled Reporting Services (2005) report has been emailed. I would like to be able to define a second SQL Agent job to execute the stored procedure that would not run until the report job has completed.
I tried adding a second step to the report job. Turns out, if the report subscription is modified, Reporting Services regenerates the job and the second step is lost.
Is my only recourse to create the second job and schedule it to run at some arbitrary time after the report job? Or is there some way to declare this job dependent upon the completion of the first?