Questions tagged [event-notification]
The event-notification tag has no usage guidance.
30
questions
0
votes
1
answer
48
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 ...
- 101
0
votes
1
answer
198
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 ...
- 111
0
votes
1
answer
262
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 ...
- 151
0
votes
1
answer
139
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 ...
- 103
0
votes
1
answer
64
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 ...
- 1,417
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 ...
- 143
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 ...
- 123
0
votes
0
answers
86
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 ...
- 129
1
vote
0
answers
354
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 ...
- 11
0
votes
1
answer
571
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 ...
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 ...
- 103
-1
votes
1
answer
171
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....
- 11.1k
22
votes
2
answers
26k
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 ...
- 321
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 ...
- 163
0
votes
1
answer
405
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 ...
- 145
0
votes
2
answers
440
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 ...
- 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,
...
- 4,697
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 , ...
- 6,247
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 ...
- 4,697
0
votes
1
answer
6k
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 ...
- 177
0
votes
1
answer
252
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 ...
- 255
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 ...
- 6,247
1
vote
0
answers
721
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" ...
- 549
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 ...
- 103
1
vote
2
answers
589
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 ...
2
votes
0
answers
285
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 ...
- 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 ...
- 649
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/...
- 433
5
votes
4
answers
999
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 ...
- 2,679
1
vote
1
answer
691
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 ...
- 2,303