» SQL Server Agent (RSS)
Sorry, but there are no more tags available to filter with.
This blog is not about avoiding logging in using the sa login. Hopefully we all know about this, and work towards avoidning this practice.
Instead I want to talk about using sa, but not to login (authenticate), but as owner for jobs and databases. I want keep these thing de-individualized - so we avoid things like person A leaving the company and ...
In what user context does a job run? I recently found myself in a forum discussion and gave my stock reply, later realizing that I haven't actually tested this for a long time (I used to demo this in class during 6.5 courses - when we actually had time for slight diversions). Lets start with my assumptions:
Job owned by sysadmin, TSQL ...