April 12, 2013 at 2:24 am
Hello,
I have set up many maintenance plans in the past, but I have found that in one environment, the plans are logging in under my username, I have set SA as the job owner. In one plan, only the DBCC runs as me and the others are ok. But on another SQL machine, all the transaction log backups are logging in as me, again the job owner is SA and the 'run as' has sql agent selected.
The problem is, I will leaving soon and my account will be deleted, I dont want the jobs to fail after I have gone. How can I resolve this?
Thank you,
Regards,
D.
April 12, 2013 at 2:28 am
What is the SQL Server agent service account?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 12, 2013 at 4:18 am
Hello Gail,
Thank you for responding. The agent is running under network service, I know this is bad practice and should be run under a domain user account, but they are migrating in a few weeks and will create such accounts for the services at that time.
What do you think?
regards,
D.
April 12, 2013 at 4:29 am
Network service is OK for SQL Agent, providing it doesn't need more permissions than network servce grants.
Double check, is it absolutely, certainly, definitely not running as your account? Double check that the jobs are not owned by you.
Where are you seeing that the jobs ran under your account?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 12, 2013 at 5:10 am
Gail,
I have double checked the job owners are not running as myself, its second nature to me to change that after creating a job, curiously this is the first time I've come across this having worked in a few different places over the years. That is what makes it so strange. However I have let them know so they will be ready if something was not to go as planned.
I just dont get why it would happen.
Regards,
D.
April 12, 2013 at 8:19 am
You can use this script to fix this problem.
Change Maintenance Plan Owner
April 12, 2013 at 9:43 am
That's great! Thanks Michael, and thanks Gail, have good weekends.
Regards,
D.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply