Questions tagged [event-notification]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
31 views

Using redis keyspace notifications to know which member was added to or removed from a set

My use case is that whenever a member is added to or removed from a set, a keyspace notification should be triggered that has information about what member was added or removed and put that pub/sub ...
Saad Ahmed's user avatar
0 votes
1 answer
134 views

PostgreSQL notifications aren't working

I'm trying to use PostgreSQL notifications but they are not working for me. Docker-Compose docker-compose.yml version: "3.8" secrets: db_root: file: ./db/.secrets/.psql_name_admin ...
Ουιλιαμ Αρκευα's user avatar
0 votes
1 answer
230 views

Is it possible to write a generic trigger for all tables in Postgres?

I want to listen to every transaction that is recorded in the database And I noticed that there is a concept in Postgres under the title LISTEN and NOTIFY (Of course, I am not sure that this is the ...
mostafa hosseini's user avatar
0 votes
1 answer
315 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 ...
Peter Nunn's user avatar
0 votes
1 answer
434 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 ...
snakecharmerb's user avatar
0 votes
1 answer
207 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 ...
Aaron B's user avatar
  • 103
0 votes
1 answer
81 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 ...
User1974's user avatar
  • 1,457
4 votes
1 answer
1k 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 ...
The pyramid's 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 ...
chrisdot's user avatar
  • 123
0 votes
0 answers
87 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 ...
Luke's user avatar
  • 129
1 vote
0 answers
396 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 ...
Dween 's user avatar
  • 11
0 votes
1 answer
643 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 ...
Rafael Dontal Gonçalez's user avatar
0 votes
1 answer
2k 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 ...
AstraSerg's user avatar
  • 103
-1 votes
1 answer
183 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....
Gaius's user avatar
  • 11.2k
23 votes
3 answers
29k 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 ...
moesef's user avatar
  • 331
1 vote
2 answers
3k 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 ...
Brandon Frenchak's user avatar
0 votes
1 answer
485 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 ...
Mehran's user avatar
  • 145
0 votes
2 answers
557 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 ...
TryNCode's user avatar
  • 217
4 votes
1 answer
2k 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, ...
Magier's user avatar
  • 4,787
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 , ...
Md Haidar Ali Khan's 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 ...
Magier's user avatar
  • 4,787
0 votes
1 answer
7k 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 ...
Guy's user avatar
  • 175
0 votes
1 answer
291 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 ...
Sauchin's user avatar
  • 265
4 votes
2 answers
17k 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 ...
Md Haidar Ali Khan's user avatar
1 vote
0 answers
791 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" ...
Bam's user avatar
  • 559
0 votes
1 answer
4k 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 ...
Chiseled's user avatar
  • 103
1 vote
2 answers
670 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 ...
Eric Humphrey - lotsahelp's user avatar
2 votes
0 answers
291 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 ...
Tom's user avatar
  • 1,539
3 votes
2 answers
19k 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 ...
simplifiedDB's 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/...
mbourgon's user avatar
  • 433
5 votes
4 answers
1k 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 ...
Eric Higgins's user avatar
  • 2,689
1 vote
1 answer
726 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 ...
ivanmp's user avatar
  • 2,323