RE: how to change the owner of the existing maintenance plan

I haven't had that happen ever, but I have had other issues with SQL 2005
Maintenance Plan jobs. I would recommend deleting it and recreating it.

Because I can change the name without issues; alternatively you can check
permissions on msdb.dbo.sysjobs; assuming your SysAdmin so you shouldn't have
to worry but I keep running to stuff in my enviornment that has been messed
around; just a thought. This is where the owner information is stored for
each job. Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"sg" wrote:

Hi,

We are using sql 2005 and I created a few maintenance plan. Because I logged
in as my windows account and the owner of maintenance plans is my account, I
wanted to change to the sql service account. I changed it throught job
properties, it goes back to my account again. I also went into the
maintenance plans and re-saved it under sql service account, it still doesn't
change.
How do I change it?

Thanks a lot,
Sarah
.

Relevant Pages

  • SQL 2005 Database Mail Fails - HERES HELP - Maintenance Plan, SMTP
    ... Here is how I got SQL 2005 Database Mail to work .... ... Send email from Database Maintenance Plan. ... Computer B = Windowns 2003 Server with a named instance of SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Bug in Database Maintenance Plans Enterprise Manager and MSDE v SQL
    ... While it is true that SQL 7 has no Database Maintenance Plan ... What I mean to say is that when creating a new Database Maintenance Plan ... using the GUI Enterprise Manager that takes one through a multi-step ... manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all ...
    (microsoft.public.sqlserver.server)
  • Re: Bug in Database Maintenance Plans Enterprise Manager and MSDE v SQL
    ... While it is true that SQL 7 has no Database Maintenance Plan ... What I mean to say is that when creating a new Database Maintenance Plan ... using the GUI Enterprise Manager that takes one through a multi-step ... manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all ...
    (microsoft.public.sqlserver.tools)
  • Re: Bug in Database Maintenance Plans Enterprise Manager and MSDE v SQL
    ... While it is true that SQL 7 has no Database Maintenance Plan ... What I mean to say is that when creating a new Database Maintenance Plan ... using the GUI Enterprise Manager that takes one through a multi-step ... manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all ...
    (microsoft.public.sqlserver.setup)
  • Re: Bug in Database Maintenance Plans Enterprise Manager and MSDE v SQL
    ... While it is true that SQL 7 has no Database Maintenance Plan ... What I mean to say is that when creating a new Database Maintenance Plan ... using the GUI Enterprise Manager that takes one through a multi-step ... manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all ...
    (microsoft.public.sqlserver.msde)
Quantcast