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?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.
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment