Fix a bug… discover another…  Hence the birth of this post. I had a production SQL Agent job that called a sub-job using the sp_start_job system stored procedure (step 1).  The next step (step 2) involved a simple update of a configuration table date column. My assumption was that when step #1 finished, step #2 [...]