sql agent job owner best practice

From: Peter (anonymous_at_discussions.microsoft.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 09:10:50 -0700

I set mine to be by the SQL Server Agent user ID I created
to run the agent.

That way I never get a problem if someone leaves.

>-----Original Message-----
>sqlserver defaults my user id as the owner of new jobs i
create.
>if my account gets deleted from ad when i leave this
company, those jobs will fail..correct?
>
>i was thinking to use the AD service account i use to run
the sql agent service. it has full rights in sql server,
but limited on the server...good idea or bad?
>
>if my account has full rights in sql server and the
server...that would be a bad idea to run the job using my
credentails...correct?
>
>or do people create a new account, like a job_owner
account, and use that one to run the jobs?
>
>what do people generally set as the job owner?
>
>thanks
>.
>

Relevant Pages