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