SQL Server Agent Permissions Checks
New Information - SQL Server 2000 SP3.
SQL Server Agent ensures that the job owner has permission to append or overwrite a file in one of the following ways:
- If the job owner is a member of the sysadmin fixed server role, the job can be written to the server.
- If the job owner is a Windows user, SQL Server tests to see if the user has permission to write to the server.
- If the job owner is a SQL Server user, SQL Server tests the SQL Server Agent proxy account for permission to write to the server. If the proxy account has not been set, no log will be written.
In all cases, jobs are written with SQL Server Agent credentials, but SQL Server now tests to ensure the user has permission to write to the server. Errors appear in the job history, but the job steps will not fail if the log file cannot be written.