Thanks Shaw.

Is it possible to call a job inside a procedure?

Hi John,

Thanks for responding. Now I did like that. I created one more procedure which can get the batch id from the physical table then call the second procedure with...