Hi all,
I have a question regarding the stored procedure results. I have two stored procedures. stored procedure [spSync_Prod2Dev] and stored [dbo].[SpEmail_spSync_Prod2Dev]. Here stored procedure [spSync_Prod2Dev] will load data from Production to DEV, this will be done every week. So ones it runs I should get an email "data loaded successfull" For this I have created another stored procedure called stored [dbo].[SpEmail_spSync_Prod2Dev], So ones stored procedure runs
exec [dbo].[SpEmail_spSync_Prod2Dev] this stored proc this willgenerate a result values either it's 0 -1 or 1 based on this output it should call this stored procedure [spSync_Prod2Dev]. If the [SpEmail_spSync_Prod2Dev] result is 0 then it should email me an "Error message" and if the [SpEmail_spSync_Prod2Dev] result is success (1) it should go the this [spSync_Prod2Dev]. stored proc and it should execute the SP ,and get an success email "Data loaded". Could you please help me on this. And I think I am clear if not you can ask me for questions.
Thanks,
sidhu