|
Can I monitor
whether SQL Backup /Restoration is successful or failed in MOM?
From the microsoft.public.mom
newsgroup and Mike Goulding
You absolutely can do it. There are already rules in place to create an
alert if a SQL backup fails. There is an option to write an NT event in case
of backup failure in the SQL Agent job. This is on by default, and it looks
like the MOM rules look for this to indicate a failure.
-
Go into the MOM Administrator Console.
-
Expand down to 'Rules
| Microsoft SQL Server | SQL Server 2000 | SQL Server Agent | Event
Processing Rules'.
-
In there you will find A SQL job failed to
complete successfully. Right click and go into 'Properties'
and Enable this rule.
|
