Hi,
It seems MS CRM 4 SQL Jobs need to run as a defined MS CRM user!
The only way that i can get a SQL query running under a scheduled SQL 2005 job is if i tell it to run as a MSCRM user who is also able to be an administrator that can send database email. it won't read the MSCRM filtered views as "NT Authority\SYSTEM"
So at present i have an admin user account tied up for running SQL jobs.
Is there a smarter way to have the SQL agent having read permissionss to views?
(I tried adding the select permission to the MSCRM database but this made no difference.)
Cheers
Stuart
Stuart