Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2007-11-05 : 14:45:36
|
| What account is recommended to be the owner of each job on a SQL server? Is SA recommended? Or should I have a specific domain account like MyServerJobsOwner and grant rights in SQL Server to run the jobs. Then make it owner of all jobs. What is suggested and what you have done in your environment.Thanks,Canada DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-05 : 14:47:47
|
| Well I typically create jobs using my Windows account, so that account is typically the owner. Occassionally though jobs will fail as SQL Server is unable to contact the domain controller to see if my Window account is authorized. This was a big problem for us in SQL Server 2000 (not in 2005 though). As a result of this, I switch to sa when I get these errors.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2007-11-05 : 14:50:16
|
| Is there any issue or risk if use SA as the job owner?Canada DBA |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-05 : 22:22:27
|
| Certain jobs need sysadmin as owner, so using sa or other sysadmin has no difference. |
|
|
|
|
|
|
Job owner