From: | Mehmet Emin KARAKAŞ <emin100(at)gmail(dot)com> |
---|---|
To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Pgagent Event Trigger Function |
Date: | 2015-04-10 08:09:49 |
Message-ID: | CANQrdXBCJWw8xz94WheLn9UGaUaQg+1wPDVZ9BHYqSJMLkxaag@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 | Content-Type | Size |
---|---|---|
pgagent.patch | text/x-patch | 19.2 KB |
pgadmin3.patch | text/x-patch | 146.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitriy Olshevskiy | 2015-04-11 19:10:59 | Re: PATCH: saving of sort-columns and order chosen by user |
Previous Message | Sanket Mehta | 2015-04-09 07:00:08 | Re: PgAgent Patch |