Home Forums SQL Server 2008 Security (SS2K8) Running SQL Agent jobs - Cannot determine if windows user has server access RE: Running SQL Agent jobs - Cannot determine if windows user has server access

  • P Jones (3/19/2015)


    SQLBill - as I said above, they already have sql agent operator role (the highest level). Without sysadmin permissions it doesn't do the job.

    Have you tried looked at using the Credential/Proxy method, this way they can keep their Operator role, while being able to run the job under an alias.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices