Questions tagged [alerts]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-2
votes
1answer
44 views

SQL Server Event Log Summary [closed]

I want to generate a daily summary of SQL Server Event Logs which will be sent via email. I have currently been able to set up SQL email alerts for error logs,but they are sent individualy when an ...
1
vote
0answers
12 views

queries to active live test health of a galera cluster

What queries could be used to foresee or better fine tune alerts to check the health status of a Galera (MariaDB) cluster? The problem I am facing is that randomly the cluster gest stalled because of ...
0
votes
1answer
47 views

SQL Alert for long running queries [duplicate]

I want to receive a mail when a query is running for more than x seconds. I know I can set up a job running on the database but, is there any way to do the same using SQL Alerts? What kind of alert ...
0
votes
0answers
33 views

SQL agent job for long running queries

I am trying to setup an alert where the application team can get the notification on their event viewer for any queries which are running longer than 2 minutes. This is what I have so far. For some ...
0
votes
0answers
19 views

Alert message to remote SQL DB form local SQL DB if no data from software application

I am looking for a solution for my software application which has local SQL DB for data storage and from the local SQL DB replicate the data in real time to a remote SQL DB for visualizing the data in ...
2
votes
1answer
79 views

how to set up sql server alerts based on a schedule basis?

We would like to stop getting sql server alerts from dev servers during the weekend. We have alerts for severity 016 to 025.
0
votes
1answer
39 views

Retrieve alert error description text via SQL Server Agent

We have configured Alerts for the major severities and error codes on our SQL Server instances. Each alert then runs the same SQL Server Agent job, to trigger an alert in our monitoring system (for ...
0
votes
1answer
34 views

Question about alerts in Oracle 11.2

I inherited an Oracle 11.2 server. I wanted to see if whomever configured it before me had any alerts configured, perhaps to notify on audit events. Logging on as sysdba, I issued this command per ...
1
vote
0answers
100 views

SQL Server Agent Alert does not pick up some of Events from Application Log written by SQL Server Audit

My end goal is to be emailed when new object (schema, table, procedure etc.) is created / altered / dropped at one of my databases on SQL Server I created a server-level audit, that writes to Windows ...
1
vote
1answer
35 views

How to get user name to appear in Alerts

Setting up some alerting in SQL server 2017 which get dispatched by email to certain DBAs. Some examples of alerting I am trying to configure would be for Alert number 229 - The EXECUTE permission ...
1
vote
1answer
56 views

Notification of row entries

I have SQL Server 2012 machine housing a database running an off the shelf application with a users table. This users table contains PII enterable fields. Per requirement none of our databases can ...
2
votes
3answers
236 views

How to set space usage alert for database using SQL Server 2012 with Amazon RDS as managed service?

I have a database whose initial size is set to 1000 GB. Is there a way where i can set an alert when the max space is used and database size is nearing to 1000 GB, for eg when it reaches maybe 995 or ...
0
votes
2answers
1k views

Getting “SQL Server Alert System: 'Alert Severity 20' occurred” error occasionally

We occasionally get following email alerts. DESCRIPTION: The login packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the ...
-1
votes
1answer
45 views

Job duration email

I have need to be able to generate two types of alerts: We have a sql job which runs every 1 hour. I need an alert to let us know the time it took to complete the job As the count for Table1 ...
1
vote
2answers
363 views

How do I automatically enable or disable report jobs at AOAG failover?

I have an AlwaysOn Availability Group with 2 DB servers. I'm attempting to use SQL Server Agent Alerts to programmatically disable a handful of SQL Server Agent jobs (that must not run on a secondary) ...
4
votes
1answer
2k views

DBA Blocking Query Email Alert

Does anyone have a good Sql Alert which sends email notifications, when query Blocking has occurred over many minutes? I know how to write my own, however seems to be a good code library on internet. ...
0
votes
0answers
51 views

Setting precedence of MS SQL Agent alerts

I've recently encountered an issue with a SQL system I've inherited. Agent alerts have been configured to trigger on Severity and on Error ID. However, it seems like a given error can only trigger a ...
2
votes
1answer
50 views

Setting Up SQL Alerts

I have turned on notifications via email on my SQL Server Agent if any of my scheduled jobs failed or is successful. Can anyone help me if I want to set up Alerts, if in case one of the scheduled job ...
3
votes
1answer
91 views

Does the @raise_snmp_trap do anything in @sp_add_alert?

I have a request from a client to incorporate SNMP Traps as the method for alerting in SQL Server. The only way I have found to do this is by using [dbo].[sp_add_alert] found in the [msdb] database. -...
1
vote
1answer
63 views

How to know exactly when my Database / Log files grew?

Is there a way to see when (history / log records) of .mdf / .ldf files grew? Ultimately, is it possible to setup alerting and know immediately when my database / log files grow?
3
votes
2answers
5k views

SSPI handshake failed with error code 0x8009030c, state 14

DESCRIPTION: SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext ...
0
votes
1answer
38 views

With foreign keys automagically dropping out, can I set up an alert?

A strange thing happened to my company's Oracle database: Foreign key constraints keep dropping out by themselves. If you could solve this problem, that would be great. But even if you can't, ...
1
vote
2answers
451 views

SQL Job is getting failed randomly while trying to send the alert email. need help

We have configured a alert which triggers the email using a job. But the job fails randomly during the day and we don't receive the alert related mails. If I clear the ExternalmailQueue it starts ...
0
votes
2answers
1k views

Need to setup a sql alert on “waiting tasks” - similar to “waiting tasks” in Activity Monitor

My manager has asked me to work upon a request. I am not sure if it is reasonable or weird but he wants me to setup an alert based on the "waiting task" that we see in the activity monitor. Basically, ...
3
votes
3answers
839 views

Cpu% usage alert is not working for 'alert if counter=raises above'

I am thinking to create an alert for Cpu usage when it crosses certain value. So i configured one alert for this and attached those screen shots here But the above alert is not working mail is not ...
1
vote
1answer
616 views

How to script alerts in SQL Server?

after trying out this script: Script out all alerts By Carolyn Richardson or even the traditional way of ssms -> right click -> script alert as none of these methods are fully comprehensive because ...
0
votes
0answers
2k views

A read operation on a large object failed while sending data to the client

A few days ago, in one of my servers, I had the following alert pop out: A read operation on a large object failed while sending data to the client. A common cause for this is if the application ...
0
votes
0answers
411 views

Why was a “default trace stopped due to not enough space on the disk” Alert email not sent until 3 days after the event?

SQL Server 2008 R2 instance sent a Severity 016 Alert: "Trace ID '1' was stopped because of an error. Cause: 0x80070070(There is not enough space on the disk.). Restart the trace after correcting the ...
0
votes
1answer
61 views

Setup mail notifications on SQL Server (severe) errors

I want to be notified by email whenever an error occurs on our production database (e.g. failed database backups, engine crashes due to corruption etc). I could not find built-in support for this, so ...
0
votes
1answer
314 views

Monitor and alerting tool for specific queries [closed]

I need to monitor and alert a MySQL DB which is hosted on AWS. I'd like an alert to trigger if certain SQL query criteria aren't met (e.g. SELECT * FROM my_table returns less than 100 results). What ...
0
votes
1answer
299 views

Can I create alert on ora-20118 from Enterprise Manager?

Can I create an alert on a user-defined ORA- error? I want EM to notify me when the following error happens: begin raise_application_error(-20118, 'myerror'); end; /
4
votes
1answer
563 views

What is preventing ORA-00376 errors appearing in the alert log?

An overnight hard drive failure had various side-effects, including leaving a single datafile needing recovery: SQL> select count(*) from v$datafile where status='RECOVER'; COUNT(*) ---------- ...
2
votes
0answers
214 views

How can I have SQL Server send Job Notification alerts to an API

I am trying to get the notifications for a job out of my email and into a chat client(HipChat). So far my googling has been less than successful so I will put the question to the community: Is there ...
3
votes
1answer
2k views

How to find High CPU queries

CPU utilization is very high and the SQL Server process is consuming a lot of CPU. We have run few queries and notice that there are a few SPIDs taking a long time to complete and these queries may be ...
3
votes
1answer
706 views

Why is deadlock alert not working?

I created a deadlock alert including notification to an operator like this: EXEC msdb.dbo.sp_add_alert @name=N'1205 Deadlock', @message_id=1205, @severity=0, @enabled=1, ...
4
votes
2answers
3k views

How do I create a SQL Agent Alert on a custom error message in SQL Server 2012?

I want operators to be notified when I throw a custom error message. My understanding is that I need to add a message to sys.messages, then I can either RAISERROR or THROW that error ID. Creating an ...
0
votes
1answer
454 views

SQL Server Alerts (notify operator when job failed)

I setup database mail, created an operator today and enable notify operator when job failed. Is that all or do I need to create an alert too? My boss just needs emails if any job failed. Also how ...
1
vote
0answers
1k views

SQL Server Alert System: 'Severity 17 - Potentially Fatal Error Insufficient Resources' occurred on myserver

I get a alert email with the title: SQL Server Alert System: 'Severity 17 - Potentially Fatal Error Insufficient Resources' occurred on myserver as 12:02 when I connect to myserver to check the ...
0
votes
2answers
1k views

SQL data deletion alert

I want to know if some data has just been deleted from my database and receive an e-mail alert with the table names which have been affected by the deletion . I have set up SQL SERVER to send e-mails,...
1
vote
1answer
154 views

Why does everyone want me to create an alert for severity 025?

Brent Ozar and others suggest to listen to severity 025 SQL-Server events. I searched for the meaning of all different high severity events, looked through different articles and read the most recent ...
2
votes
1answer
59 views

Strange Backup and Alerting Issue

I received alerts from one of my database servers over the weekend that was somewhat disconcerting. There was an alert for each single database within the maintenance plan. A full backup has never ...
0
votes
1answer
861 views

Alert and notification option in job properties

During SQL Agent Job configuration I see the options to define ALERT and NOTIFICATION. I see that notification is what I'd expect, a notification of a job failure for example. But I do not understand ...
2
votes
2answers
277 views

Random and constant “Log Growths” Alerting, how to make it stop?

I've set up alerting on all my database servers and every once in awhile I'll get the following error, sometimes it goes on and on and on, other times it'll be a few times here and there. The SQL ...
3
votes
1answer
955 views

How can I create notification on user's connecting to database?

I have users that have access to several databases. I used to have an alert and notification sent to me when a specific user connects to a specific database, but I accidentally clobbered it. Now I ...
1
vote
2answers
1k views

Way to test alerts for backups?

We have some SQL Servers that are backed up using T-SQL and some that are using 3rd party backups (like Egnyte). Is there a way to setup alerts inside SQL Server for that? I also need a way to test ...
1
vote
1answer
148 views

What should I monitor on the SQL Server machine? [closed]

I need to create some alerts, logging jobs and monitors on a machine that is going to run SQL Server 2012 Standard for an ERP system. The OS will be Windows Server 2008 R2 Standard/Datacenter (if it ...
1
vote
1answer
417 views

Raising an Alert with THROW

It seems to me that SQL THROW is missing a crucial feature that RAISERROR has, and that is the abilty to use WITH LOG so that an Alert can be fired when the error number is logged in the Application ...
1
vote
1answer
4k views

Throw and RaiseError of level 16 do not cause alert to occur

The next alert has been created: USE [msdb] GO /****** Object: Alert [Notify] Script Date: 09/09/2014 11:38:31 ******/ EXEC msdb.dbo.sp_add_alert @name=N'Notify', @message_id=0, ...
1
vote
3answers
1k views

Notification email when deadlock is encountered in Oracle alert log

How to send a notification email when a deadlock is encountered in alert log on any node like the deadlocks encountered below? (an alert any time a deadlock is detected in alert log) Node 1: Mon Sep ...
4
votes
2answers
2k views

Alert when Job isn't triggered

I have a Sql Job on my server that is triggered nightly from a remote server (once it has completed its backups). I have successfully configured the job to notify me when it fails, but I would like ...