AnsweredAssumed Answered

On Stop Behaviors

Question asked by chefcore on Jul 10, 2019
Latest reply on Jul 11, 2019 by breuber



Does anyone have a definitive guide or understanding of how the different procedure 'on stop' behaviors work? I am most interested in understanding the implications of "Must be executed until the end." My current issue is that, if a procedure is running and a data reader kicks off (even in another database), the procedure stops, with the message that it failed due to "frozenprocedures.dbo" I am wondering if i can force the procedure to wait to continue by choosing a different 'on stop' behavior. Any thoughts are appreciated.