hi

Thanks for the reply. The condition is based on data from a table. The script i have written in the sql command of sql job is simply like this

declare...

Is there any option (work around) by which we can edit the table variables ?