Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1077
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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