Wednesday, March 7, 2012

job permission

jobs are running with agency account. when using dynamic sql, you have set sp 
WITH EXECUTE AS OWNER or grant the SELECT permission to agency account.

No comments:

Post a Comment