0

I have a stored procedure which needs to sequentially execute one after another (after completion of one and it should go for next stored procedure execution).

For example:

Exec [dbo].[usp_UpdateUTCDateForCustom] CacheExpirationPolicy , ModifiedOn
GO
Exec [dbo].[usp_UpdateUTCDateForCustom] Consumable , CreatedOn
GO
Exec [dbo].[usp_UpdateUTCDateForCustom] Consumable , ModifiedOn

How can I run the above stored procedures to run sequentially?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
SESHI
  • 33
  • 2
  • 7
  • 3
    What's wrong with the example above? – Szymon Dec 22 '13 at 07:49
  • You **ARE** executing them sequentially...... so what is your question, really?? – marc_s Dec 22 '13 at 07:51
  • Will the 3 SPS Executes at a time or will go sequantially..One after the other.. I need to execute the SPS one by one..i.e., after the completion of SP1, SP2 shud execute and go on.. – SESHI Dec 22 '13 at 07:51
  • That's exactly what will happen here: the first procedure executes, and if no errors are encountered, the second will run after the first is done, and so on. No parallelism - one after the other – marc_s Dec 22 '13 at 08:10

0 Answers0