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.