Not as simple as that, sorry
Two distinct jobs which one with different steps, that is why I am having difficulties: crying:
Why not get the jobs to call each other, End of Job 1 Start Job 2, End of Job 2 Start Job 3
Create a logic table, end of Job 1 Populate a table with a row of value 1. end of Job 2 Populate a second row with value 1. job 3 running always, if sum(value) = 2 exec sp_churnrate reset the values to 0. rinse and repeat or go with IF TableA.Date = CONVERT(DATE,GETDATE()) AND TableB.Date = CONVERT(DATE,GETDATE()) EXEC sp_churnrate.
Problem with the latter option if the job is constantly running to check if the values match then the stored proc will always be running.
Great, Many thanks,
I will try to build something with your first solution, I hope I can do it :D, still a newbie when it comes to SQL
All help and Any help is appreciated