December 17, 2002 at 7:11 am
Do I have this right?
When scheduled Jobs run, they execute under the security context of SQL Agent. However, BOL says that when sp_start_job is invoked by a member of sysadmin role, the Job runs under security of SQL Server (which can be different than SQL Agent).
Question: is there a difference when invoking a Job via EM (right-click, Start Job) vs. sceduling the Job?
December 17, 2002 at 8:33 am
Probably. Wehn you run sp_Start_job or click EM, you execute the stored procedure in your context, which executes the job.
If you let the schedule kick it off, that thread is already running as SLQAgent.
Since they are the same on my boxes, never noticed.
Steve Jones
December 17, 2002 at 10:02 am
I agree with Steve. I use different accounts for the two on some of the systems I work with and have observed that behavior
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply