Questions tagged [event-notification]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
30 views

Broken database trigger in postgresql

I have a database with a bunch of insert triggers (5) that fire pg_notify events. These have all been working happily for about a year until 12:00 today where one of them seems to have come to a ...
user avatar
0 votes
1 answer
112 views

How can the size of the notification queue be configured?

The documentation for NOTIFY states The queue is quite large (8GB in a standard installation) and should be sufficiently sized for almost every use case Is it possible to configure the size of the ...
user avatar
0 votes
0 answers
1k views

Can a Postgresql trigger send a row to an api via a post request

I have an application where it would be really nice to be able to use an insert trigger on a table to format and send a post request to an external API. This would save me having to write the code to ...
user avatar
0 votes
1 answer
96 views

Oracle live data updates for frequently updated table: poll or CQN?

My team is looking at getting live updates from our Oracle database from a frequently updated table. I have discovered CQN and configured a test environment to use UTL_HTTP to POST to a webhook when ...
user avatar
  • 103
0 votes
1 answer
57 views

Get notification about invalid views

I have 40 views that are integrated/synced to a work order management system on a weekly basis. The views are based on GIS tables which are notoriously messy. Over time, the views can end up becoming ...
user avatar
  • 1,389
4 votes
1 answer
975 views

How to send only updated values of a row?

CREATE OR REPLACE FUNCTION notify_col() RETURNS trigger AS $BODY$ BEGIN PERFORM pg_notify('channel', row_to_json(NEW)::text); RETURN NEW; END; $BODY$ LANGUAGE plpgsql ...
user avatar
1 vote
1 answer
2k views

Query notification equivalent for SQL Server 2016

I was looking for query notification to get notified on multiple client for a specific table changes. It seems that this feature has been removed in SQL Server 2008 R2. Documentation is not very clear ...
user avatar
  • 113
0 votes
0 answers
83 views

Automating Alerting on Blocking with Queues and Event Notifications [duplicate]

I need to automate email notifications on blocking on some SQL 2016 servers. I have had a look at running a job through the SQL agent but seems hack n slash. I found an alternative method online that ...
user avatar
  • 129
1 vote
0 answers
326 views

Basic Database Design for Story Sharing

Tables: Users User_profile -------- ------------- user_id(PK) user_profile_id(PK) username user_id(FK) password display_name date_created ...
user avatar
  • 11
0 votes
1 answer
504 views

Generate Script for Event Notification

I need to migrate my Event Notifications from current server to another one. I would like to generate that code, but I couldn't find an way to do that. Try 1 I have tried reverse engineering from ...
user avatar
0 votes
1 answer
1k views

How to persist messages in Postgresql's LISTEN/NOTIFY? [closed]

If I send notifications before starting to listen i.e. notify test, 'test message'; listen test; I loose that notifications. How can I persist them for later fetching? Actually, I need this ...
user avatar
  • 103
-1 votes
1 answer
151 views

Expected behaviour of query notifications

I am using the Microsoft ODBC driver on a Linux system to connect to SQL Server 2012 on Windows to use the Query Notification feature. I run my C code and can see my subscription appear in sys....
user avatar
  • 11.1k
21 votes
2 answers
25k views

Postgres Listen/Notify As Message Queue

Is there any way to use Postgres Listen/Notify feature to deliver a message to a channel and have only one listener consume this message? The purpose for this is that I have multiple 'worker' apps ...
user avatar
  • 311
1 vote
2 answers
2k views

Oracle DBMS Scheduler Email Notifications Dynamically Send Server and Instance Name

We have two Oracle database servers. One for production with one instance on it, and another one with multiple instances for Dev, Test, etc. I have some jobs that run on production and email me when ...
user avatar
0 votes
1 answer
339 views

Sending an async notification to another database in PostgreSQL

Is there any way I can send a NOTIFY to a database other than the one that my connection has specified? [CLARIFICATION] Consider we have two databases within one instance of PostgreSQL. If you are ...
user avatar
  • 145
0 votes
2 answers
399 views

Notify when database is accessed in any manner

I'm using SQL Server 2012. Is there a way to receive a notification (email/log etc..) if a database or table in a database is touched in anyway (e.g. CRUD via Stored Procs or tables opened via ...
user avatar
  • 217
4 votes
1 answer
1k 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, ...
user avatar
  • 4,605
2 votes
1 answer
3k views

Is it possible to configure multiple database mail id in single account name in sql server 2012?

I would like to say that as i want to configure multiple database mail in single account name in sql server 2012. This is SQL-Cluster-DB , so as per direction from head, If any sql job will fail , ...
user avatar
0 votes
1 answer
1k 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 ...
user avatar
  • 4,605
0 votes
1 answer
5k views

Trouble Shooting "Unable to complete login process"

Issue On one of our SQL Server witness servers (This is part of our Database Mirroring setup for SQL Server 2008 R2) we have just started getting the below event in the windows event log. The ...
user avatar
  • 177
0 votes
1 answer
229 views

Oracle: Performance centric ways to notify user on reaching "logical" lock expiration event

Current Setup: My application uses Java (Spring) and Oracle 11g and has functionality where logical locks are placed on an object before updates are made in the table. For example there are 2 ...
user avatar
  • 245
4 votes
2 answers
16k views

AppDomain 2 (mssqlsystemresource.dbo[runtime].1) is marked for unload due to memory pressure message in SQL Server Log

From last two days I can see following in SQL Server errorlog. AppDomain 2 (mssqlsystemresource.dbo[runtime].1) unloaded. & AppDomain 2 (mssqlsystemresource.dbo[runtime].1) is marked for unload ...
user avatar
1 vote
0 answers
640 views

Better way to create an Events table?

I working on a medium sized PostgreSQL database with some schemas, each with some tables. In almost every schema there are tables that represent event tables, where something that has "happened to" ...
user avatar
  • 531
0 votes
1 answer
3k views

Customizing OEM notification title and body

I am writing a reporting tool that accepts email notifications for incedents , alerts and events coming from the OEM. The tool parses the email title and body to extract information from it. I was ...
user avatar
  • 103
0 votes
1 answer
522 views

Possible to CREATE EVENT NOTIFICATION with a different owner?

We are in the process of removing a previous dba login and he owns all the endpoints and event notification objects. Endpoints were easy to change; Event notification objects not so much. I found ...
user avatar
2 votes
0 answers
283 views

WMI event alerts

I am trying to understand WMI event alerts and have implemented a mirror with alerts on DATABASE_MIRRORING_STATE_CHANGE such that all database failover if the state is either 7 or 8 (manual failover ...
user avatar
  • 1,529
0 votes
0 answers
50 views

mySql Event gets expired on closing of the command prompt

As I am quite new to server side, I tried to create a event using CREATE EVENT enetname ON SCHEDULE AT '2013-06-13 18:00:00'+INTERVAL 30 SECOND DO update tablname set status= 'Expired' where ...
user avatar
3 votes
2 answers
18k views

Updating a column after expiration of specific time in MySQL

I have a table where I have a column named state(int(2)) and modify_time (time_stamp on update current timestamp). I have an update trigger which changes the value of state column to 0 based on some ...
user avatar
3 votes
0 answers
2k views

Event Notification / Service Broker - no inserts anymore, "previously existing connection with the same peer"

I've been working on getting several servers to feed Event Notifications to a central server. Had everything working yesterday, then managed to break it. Dropping and recreating the endpoint/route/...
user avatar
  • 433
5 votes
4 answers
996 views

Recommendation for free event monitoring software

I'm seeking recommendations for free / open event monitoring tools. HPOV costs continue to multiply like so many wet gremlins, and we've had enough. There are some interesting suggestions in this ...
user avatar
  • 2,679
1 vote
1 answer
657 views

Recommendations on creating user-objects on system database

I want to setup a bunch of Event Notifications on SQL Server using Service Broker for our production database. I've setup a new database on my testing machine, and everything works well. The problem ...
user avatar
  • 2,302