February 29, 2012 at 6:49 am
I have several SQL Agent Jobs that are part of a proprietary software used here. Each of these jobs calls a stored procedure that in turn calls another stored procedure etc. I want to combine these into one job with multiple steps. My question: does one step finish before the next one starts? What I mean is does the entire series of stored procedures that a step calls finish before the next step starts or does the first call to a stored procedure make the step think it is finished? Since the execution time in history is a second or less I assume that once the first stored procedure is called, the steps considers itself done. Any help or ideas around making sure a step finishes all its processes before moving to the next step.
Thanks,
Jim Lewis
February 29, 2012 at 6:51 am
A step has to complete totally before the step is complete and the next one can start.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply