Hi Erik,

Thanks for your reply. I appreciate your help.

I am 100% sure that the connections used are one and same either from IDE or through SQL Agent. It works perfectly...