Thank you Ed, your solution works. BTW, i have added the sqlserveragent with role proc_executor membership and everything went well.

Hi Ed,

After inserting Execute as login getting this error

The server principal "xxxx\SQLServerAGENT" is not able to access the database "xxxx" under the current security context.

stored proc UTL_QueryToHtmlTable script (this is...

Hi Orlando, thanks for your reply. Change to

N'select * from xxxx.dbo.vwPOSInventoryAdjustment'

Still doesn't work. Any further suggestions?