Thanks for all your help and suggestio. At this point it seems it might be easy to update in two place separately. I will look further into this. let you...

Thanks for reply! can you please elaborate on these. I am anewbie and not exact fimilar with. I will appreciate guide me here. Another thing is only one field...

still same error message.

Thanks for replying. I have tried to do that but it gives me a error "unable to cast object of type 'Microsoft.sqlserver.management.smo.simpleobjectkey' to type microsoft.sqlserver.management.smo.agent.'jobobjectkey'."

I ma not sure where i...