SQL Job Execution rights

I have a SQL 7.0 server which has a SQL job which includes a step to run a DTS package. The step uses the CmdExec and DTSRun to run the package.

I need to allow a non-sa user (userX)access to run the SQL job.

When I set the job owner to userX, the user can see the job and execute it but it fails with a message:

Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: A required privilege is not held by the client).

How can I configure the SQL job so that userX can run it successfully??

Thanks.

Try reset password for SQLAgentCmdExec in sql agent properties.

I have reset the password in SQL Agent. But I am still getting the following error in my SQL Agent error log
on startup:

[000] Password verification of the 'SQLAgentCmdExec' proxy
account failed (reason: A required privilege is not held
by the client)

Does the password have to be something special. SQL Agent does not let me set the password it just "resets" it.

Go to sql agent properties -> job system in em and ensure the box besides 'only users with sysadmin ...' is unchecked.

Turns out it was a problem with the account that was configured to run SQL Server and SQL Agent not having the appropriate permissions on the local box.

Permissions needed -
MSSQLServer and SQLServerAgent Services:
Act as part of the Operating System.
Increase Quotas.
Replace a process level token.
Log on as a batch job.


SQLAgentCmdExec Account:
Log on as a batch job

Once we changed the permissions and restarted SQL Agent everything worked fine. Thanks for your help.