Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [event-notification]

32 questions
25
votes
3 answers

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 all listening to the same Postgres channel. But I…
moesef
  • 351
  • 1
  • 3
  • 4
5
votes
4 answers

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 article and the subsequent comments, but before I set…
Eric Higgins
  • 2,689
  • 1
  • 19
  • 25
4
votes
1 answer

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 VOLATILE COST 100; I'm trying to listen on channel,…
The pyramid
  • 143
  • 5
4
votes
1 answer

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, @delay_between_responses=30, …
Magier
  • 4,827
  • 8
  • 48
  • 91
4
votes
2 answers

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 due to memory pressure. I have system environment like…
Md Haidar Ali Khan
  • 6,523
  • 9
  • 40
  • 62
3
votes
2 answers

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 condition. I want to set the value of state…
simplifiedDB
  • 679
  • 6
  • 18
  • 36
3
votes
0 answers

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/event notification on the "sending" server…
mbourgon
  • 433
  • 3
  • 10
2
votes
0 answers

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 or automatic) Yesterday my mirror failed over but…
Tom
  • 1,569
  • 6
  • 29
  • 43
2
votes
1 answer

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 , then notification should be myself (i,e; DBA) as…
Md Haidar Ali Khan
  • 6,523
  • 9
  • 40
  • 62
1
vote
0 answers

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" or was "caused by" a user is inserted. Essentially…
Bam
  • 579
  • 1
  • 5
  • 10
1
vote
2 answers

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 this thread about changing the owner of an event…
Eric Humphrey - lotsahelp
  • 5,033
  • 1
  • 25
  • 29
1
vote
1 answer

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 db_pwd: file: ./db/.secrets/.psql_pwd_admin …
Ουιλιαμ Αρκευα
  • 269
  • 1
  • 3
  • 10
1
vote
1 answer

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 about that. When exactly has this been removed…
chrisdot
  • 143
  • 1
  • 6
1
vote
0 answers

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 birth_date last_login …
Dween
  • 11
  • 1
1
vote
1 answer

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 is that I'd rather not have to deploy a whole…
ivanmp
  • 2,323
  • 3
  • 24
  • 36
1
2 3