Pgagent Event Trigger Function - Mailing list pgadmin-hackers

From Mehmet Emin KARAKAŞ
Subject Pgagent Event Trigger Function
Date
Msg-id CANQrdXBCJWw8xz94WheLn9UGaUaQg+1wPDVZ9BHYqSJMLkxaag@mail.gmail.com
Whole thread Raw
List pgadmin-hackers
Hi,

We are using pgagent for very important works. pgagent is runing seventy five cron for now and this number grow up. So we need a event trigger function for fail or succeed steps. We use this function for monitoring or trigger another function. For Example; if one step failed , we send sms to some technician.
I added some code in pgadmin and pgagent project. I added trigger tab and enable trigger checks in pgadmin3 job step window and pagagent code review this way. I added trigger support control  if necessary code. Triggers run batch file or SQL. I attached the pgadmin3 and pgagent patch file in this mail.
We necessary one table extra. I added in pgagent (/sql/pgagent.sql ).

Best Regards...
MEHMET EMİN KARAKAŞ
Attachment

pgadmin-hackers by date:

Previous
From: Sanket Mehta
Date:
Subject: Re: PgAgent Patch
Next
From: Dmitriy Olshevskiy
Date:
Subject: Re: PATCH: saving of sort-columns and order chosen by user