Microsoft SQL Server forum - Job invoked by Alert but Alert never occured

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Job invoked by Alert but Alert never occured

Stephanie

2005-09-27, 8:24 pm

I have a problem with an Alert that is supposed to invoke a Job. Here
are some details:

Windows Server 2000
SQL Server Standard Ed. ver. 8.00.818 (Sp3)
Alert: SQL Server performance condition alert; Counter: Percent Log
Used; If the counter rises above 90% the response is to execute Job.
Job: Transaction Log backup; set up through the Database Maintenance
Plans. This job runs a backup hourly during the day, on a couple of
the Databases; yet also runs if the Alert is triggered. (This part
works fine.)

The problem I am encountering is where the job is running because it
was invoked by Alert 10. Yet, the Alert (10)registers Zero occurances.
The Job will then start getting into a cycle where the Job launches
every minute stating the whole time that Alert 10 invoked it.

How do I get this job to run only when scheduled and/or when triggered
by the alert?

Thank you,
Stephanie

Sponsored Links