Hi Phil,

Its NT Bacth Job....

I am going to convert it into SQL job.

While the Script does not prompt i/p value for executing corresponding Procedure if its by SQL job

If i creat SSIS package it will prompt i/p value for which procedure to execute.

I may give 'S' or 'D' or 'T' or '' based on my requirement....

Thanks,

Sasidhar P