I have SQL Script consists of one batch file followed by proc2,proc3
my requirement is,,when we run script first batch file should after complated of batch file execution only .execution of proc2 should start
..etc
example
script
@declare...
batch file
proc2(should start execution only if batch file execution completed)
proc3(should start execution only if proc2 execution completed)