I have created a sp to activate the job in SQL Server. And from VB, I will call the that sp. In that sp, I need the sp to return me value of 0 or 1 to determine the process is successul or failed. But, I have 1 question. How to make the sp/vb to wait until the job activity has finished and then return the value of 0 or 1? I have tested my sp where it will not wait for the job activity to complete, and it is straight away goes to next statement in the sp.
DOes anyone can help? Please.