Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1069
  • Last Modified:

Failed to run job with "run as"

I have a job which should exe3cute the stored procedure, when I execute the job with "run as user" in job properties, I got the error message like below. But when I empty the "run as user" it work fine to execute the job. what is wrong here ?


Executed as user: domian1\kamry. Cannot find the object "%" because it does not exist or you do not have permissions. [SQLSTATE 42000] (Error 1088).  The step failed.
0
motioneye
Asked:
motioneye
1 Solution
 
JestersGrindCommented:
Are you sure that the user domain1\kamry has execute permissions for that stored procedure?

Greg

0
 
Alpesh PatelAssistant ConsultantCommented:
to execute job with sepcific use need permission to execute sp.
0
 
VENKAT KOKULLASQL Server DBACommented:
Here you need to give Complete Admin Rights for SQL and also add the local account to logins with granting full rights..

might it will helpout
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now