sql agent job owner best practice
From: jason (jason_at_discussions.microsoft.com)
Date: 07/23/04
- Next message: Hari Prasad: "Re: adding windows user via sp_cmdshell"
- Previous message: Peter: "conditional editing permissions for table"
- Next in thread: Peter: "sql agent job owner best practice"
- Reply: Peter: "sql agent job owner best practice"
- Reply: Russell Fields: "Re: sql agent job owner best practice"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 23 Jul 2004 08:15:03 -0700
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
- Next message: Hari Prasad: "Re: adding windows user via sp_cmdshell"
- Previous message: Peter: "conditional editing permissions for table"
- Next in thread: Peter: "sql agent job owner best practice"
- Reply: Peter: "sql agent job owner best practice"
- Reply: Russell Fields: "Re: sql agent job owner best practice"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
