473,800 Members | 2,623 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Job invoked by Alert but Alert never occured

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

Sep 27 '05 #1
0 1680

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
3223
by: Charles Jamieson | last post by:
I declare a class class myClass{ public: ~myClass();
11
1238
by: Hrvoje Vrbanc | last post by:
Hello, I have the following problem: I have a DataGrid control on my page with a column with TextBox controls and another one with ImageButton controls. In order to force a call to JavaScript client-side script when ImageButton is pressed, I added the following code to OnItemDataBoundEvent (check for Item Types not shown here): Dim tbKolicina As TextBox = e.Item.Cells(6).FindControl("tbKolicina")
2
1115
by: Ike | last post by:
Can someone please point out to me (what must seem obvious -- except to me!) why the following simple snippet does not work in MSIE? Thanks, Ike <html> <head> <SCRIPT LANGUAGE="Javascript"><!-- function startClock(){ alert("I never get here!");
5
3493
by: Bill | last post by:
This database has no forms. I am viewing an Access table in datasheet view. I'd like to execute a macro to execute a function (using "runcode"). In the function, I'll reading data from the record the cursor was on in the datasheet at the time I executed the macro. So, the questions are: 1) In the macro, how to I get my hands on the record key or record data of the record the cursor was on in the datasheet at the time I executed the...
31
6173
by: Zytan | last post by:
Everything (er, every class) in C# has ToString() which is conveniently automatically invoked when using it in Debug.WriteLine() or in a string concatenation, etc. I made a struct, and I want to make a method to print out its data in a similar format. So, I did this: public struct MyStruct { public override string ToString() {
9
2500
by: johkar | last post by:
I need some browser implementation clarification. In the below example, the alternate stylesheet could be invoked by user agents that support alternate stylesheets or by script. Are there any browsers that don't recognize "alternate stylesheet" as a value of the rel attribute and just implement it automatically thus overriding sheet2.css? Just need to know what I need to worry about. <link href="sheet1.css" rel="stylesheet"...
1
1502
by: riyadh81 | last post by:
can any one help me about the following issues. i m working in a web based ERP implementation team. some time php & mssql generates different types of errors. some time user reports errors to IT. without understanding the exact reason why the error occured. so i want to get an email regular basis when an error will occured in php & mssql during surfing over the net. this email will be error reporting mail which will inform about latest...
5
7914
by: michaelscript | last post by:
Here is a simple code : <input type="checkbox" id="ck1" onclick="func1('para1')"> <script> alert(ck1.onclick); //result of this: ///////////////////// function anonymous () { func1('para1') }
7
1573
by: Nick | last post by:
Hi there, Is it possible to tell how a WebMethod was invoked? For example I would like to determin if it was invoked via SOAP or HTTP Post. Other than creating 2 methods I am no sure if I can do this. Many thanks for your time. Nick.
0
9691
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9551
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10279
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10255
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10036
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6815
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5607
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4150
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3765
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.