-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|