Job owned by a non-sysadmin fails to run

Hi,

The preblem has been already discussed but none of answers help me.

I have a SQL Server 2000 SP4. Users that are not sysadmins create jobs for
SQL Server Agent. These jobs consist of a single CmdExec step.

As advised in many posts I created a Proxy SQL Server Agent account
(sqlproxy) but this did not help me, the jobs still fail to run. This
account is a windows account. I made this account belong to the sysadmins
role of SQL Server.

Both SQL Server and SQL Server Agent run under a special account
(sqlservice).

I added the account sqlservice to Administrators as advised in the article
http://support.microsoft.com/kb/833559 and even added to Administrators the
account sqlproxy, although the article states I did not have to.

The message I get in EventLog is like below:
--- message start
SQL Server Scheduled Job '<job name>' (0xEFC686299E5B9249957CC5FCF5C782C4) -
Status: Failed - Invoked on: 2006-12-18 12:06:06 - Message: The job failed.
The Job was invoked by User <domain>\<user>. The last step to run was step
1 (<step name>).
--- message end

The command of the CmdExec step runs fine if I login as user as well as
sqlproxy.

I set the output file in advanced properties of the CmdExec step but did not
see in that file anything. Looks like the job does not start at all.

When I add user aco*** to the group Administrators the job runs
successfully, but this is definitely not an option.

I would appreciate any help as I run out of ideas already.


.