Regular Maintenance Problem

[HisMightiness]

I am running SQL Server 2000 Standard. I need some help setting up my Maintenance Plan. I have set one up as a test to see if it would work. I pretty much left everything default except the times that it would run.

I am afraid I do not know exactly what other information to provide in order to help you help me. However, whenever each of the database maintenance jobs run they fail. I have tried them running as an admin account and as "sa". The event only tells me the obvious, that the job failed and what user it ran under.

What would be some common solutions to maintenance plans failing?

Will

http://www.ServiceRank.com/

 

[SQLBill]

Is the SQL Server Agent service running at the time? Jobs use that service. What Login does the SQL Server Agent service run as? That's the login that has to have access to everything the maintenance job will affect.

Right click on the failed job, select View Job History. Check the box "Show Job Steps". That might give further error messages. Check the Management>SQL Server Logs for any error messages. Check the Windows Event Viewer logs for any error messages that might relate to the issue.

-SQLBill

 

[HisMightiness]

How could I tell if the Server Agent wasn't running? As far as I know it doesn't stop running.

I have used a local administrator account, a domain account with admin rights to the server, and the sql server SA account to run the jobs.

By looking at the job steps, I have an error message:

"The job failed. Unable to determine if the owner (DOMAIN\USER) of job DB Backup Job for DB Maintenance Plan 'TESTDBPLAN' has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\USER'. [SQLSTATE 42000] (Error 8198))."

The account mentioned has administrator permissions on the server, and the maintenance plan (to my knowledge) is not trying to do anything outside the server itself. I get the same thing if I run it under the local administrator or sa accounts.

Will

http://www.ServiceRank.com/