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.