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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How do I prevent Owner change of Maintenance Plan?

Author  Topic 

AndreasMeyer
Starting Member

9 Posts

Posted - 2008-08-26 : 08:28:12
Hello,

every time I edit a maintenance plan the owner changes to my current windows login. Often I forget about this and the job does not run, because the SQL-Server services do not run with a domain account and cannot resolve the local server accounts.

I do NOT want ownership transferral to my current windows user. It should keep running with a certain local account on the server. However, for other reasons and for practicability I have to log on with my domain account when changing/creating jobs. How can I accomplish editing with my domain account and still keep ownership of the local server account for those jobs?

Thank you.
   

- Advertisement -