A job executing stored procedure, when I start the job and it is running successfully, the stored proc in job running successfully. However I don't see any changes in functionality. When I added a sql user in advanced settings in that stored proc step, then it ran successfully with functionality changes. The remaining jobs are running good with no changes. Now, I don't really understand why it is behaving like this :|
