Take the 2-minute tour ×
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. It's 100% free, no registration required.

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:

USE MSDB
GO
SELECT GETDATE() AS 'ExecutionTime'
GO
SELECT @@SERVERNAME AS 'SQLServerInstance'
GO
SELECT j.[name] AS 'JobName',
Enabled = CASE WHEN j.Enabled = 0 THEN 'No'
ELSE 'Yes'
END,
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]
GO

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.