Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2001
    Location
    Akron
    Posts
    11

    Question Unanswered: Change Object Ownership

    I'm running SQL2K on an Win 2K Server. Because of addition of additions to our network, we've installed AD on the Win 2K to graduate
    it to a Domain Controller Server. Checking the event log, one finds
    an ownership warning:

    Event Type: Warning
    Event Source: SQLSERVERAGENT
    Event Category: Job Engine
    Event ID: 208
    Date: 1/15/2002
    Time: 8:00:01 PM
    User: N/A
    Computer: XXXXX-XXX
    Description:
    SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' (0x72097D93A71E1842AA6C46E6AC59750B) - Status: Failed - Invoked on: 2002-01-15 20:00:01 - Message: The job failed. The owner () of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' does not have server access.

    I believe this warning is generated because the SQLServer system is
    looking to execute the DB Backup plan using the new Domain
    administrative account. I came to this conclusion after reviewing
    replication ownership warnings in the event log. I was easly able to
    change replication jobs from then new Domain administrative account
    to sa.

    I would like to change the ownership to sa for a Maintenance Plan.
    Is there a way to do this? Is this the solution?

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    You would be better off not using a maintenance plan but coding the requirement yourself in a stored procedure. It is very easy to do and gets round these problems as you know what it is doing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •