Failing MOM Grooming SQL Server
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Failing MOM Grooming SQL Server

 
Post new topic   Reply to topic    Windows Server Forum Index -> MOM
Author Message
Marlon Brown
Guest





Posted: Mon Oct 31, 2005 5:51 pm    Post subject: Failing MOM Grooming SQL Server Reply with quote

MOM2005 SP1. SQL 2000SP3.

I go to the SQL enterprise manager, I acess the respective MOM grooming job.
I see it is "red".

Then I start the grooming job manually. It works, it change status to
"succeeded".

Then later I keep getting below erros in MOM again. How can I fix this ?





Severity: Critical Error

Status: New

Source: SQLSERVERAGENT

Name: A MOM Grooming SQL Server Agent job failed

Description: SQL Server Scheduled Job 'MOMX Partitioning And Grooming'
(0x8F56F14CE8550F4286C55EB5BAC43D6E) - Status: Failed - Invoked on:
2005-10-31 00:00:02 - Message: The job failed. The Job was invoked by
Schedule 11 (Every day at midnight). The last step to run was step 1
(Partitioning).
Back to top
Gonzo
Guest





Posted: Mon Oct 31, 2005 5:51 pm    Post subject: Re: Failing MOM Grooming SQL Server Reply with quote

I would first check to see what time your Groom job starts and check if
anything else is runnig, like a backup.


"Marlon Brown" <nomail@brown.com> wrote in message
news:uDvJ4aj3FHA.1140@tk2msftngp13.phx.gbl...
Quote:
MOM2005 SP1. SQL 2000SP3.

I go to the SQL enterprise manager, I acess the respective MOM grooming
job. I see it is "red".

Then I start the grooming job manually. It works, it change status to
"succeeded".

Then later I keep getting below erros in MOM again. How can I fix this ?





Severity: Critical Error

Status: New

Source: SQLSERVERAGENT

Name: A MOM Grooming SQL Server Agent job failed

Description: SQL Server Scheduled Job 'MOMX Partitioning And Grooming'
(0x8F56F14CE8550F4286C55EB5BAC43D6E) - Status: Failed - Invoked on:
2005-10-31 00:00:02 - Message: The job failed. The Job was invoked by
Schedule 11 (Every day at midnight). The last step to run was step 1
(Partitioning).

Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> MOM All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB