Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm slowly untying all the system dependencies to the previous DBA's system account and moving them to a service account. The old DBA had ownership of all the jobs in our maintenance plan. In SSMS I can change the ownership directly and verify the changes have been applied with this query:

SELECT GETDATE() AS 'ExecutionTime'
SELECT j.[name] AS 'JobName',
Enabled = CASE WHEN j.Enabled = 0 THEN 'No'
ELSE 'Yes'
l.[name] AS 'OwnerName'
FROM MSDB.dbo.sysjobs j
INNER JOIN Master.dbo.syslogins l
ON j.owner_sid = l.sid
ORDER BY j.[name]

However when I modify the maintenance plan and save the ownership reverts to the old DBA account. I've combed through the GUI for a reference to his account but I can't find one.

Why is this happening and what I do I need to change to keep the maintenance plan from overwriting Job ownership.

share|improve this question
up vote 4 down vote accepted

There is a bug report on Microsoft Connect. There are workarounds in that link.

share|improve this answer
Thanks so much for the quick response! – BZN_DBer Feb 23 '12 at 19:01

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.