Re: Email notification pgAgent

Hi,

back to the main topic: Email notification.

This week I tried to use the wxSMTP library for the email notification
feature - without success. There are two versions of the lib. One will not
be supported in the future, the other is an alpha or beta. I hope this
extensions will be available as a contrib module for wx in the near future.
I also couldn't find any other multi platform library, which is open source.
Do you know one?

Another idea was to use a command line tool, which is available for *nix and
windows (http://caspian.dotconf.net/menu/Software/SendEmail/) and invoke it
via Exec in pgAgent.

Is this a practicable way for you?

Jasmin

2010/12/31 Dave Page <dpage(at)pgadmin(dot)org>

> On Wed, Dec 29, 2010 at 7:30 PM, Jasmin Dizdarevic
> <jasmin(dot)dizdarevic(at)gmail(dot)com> wrote:
> >
> > Hi,
> > I'm not so keen on that - it could require some funky code to ensure
> > that the user uses sequential (or at least, non-duplicate) numbers
> > across all steps and would be a pain to upgrade to. Plus, there is
> > precedence for using alpha ordering - that's how triggers work
> >> I don't think that we must ensure that no duplicate values are used.
> With
> >> changing the "order by jstname,jstid" clause to "order by
> >> jstorder,jstname,jstid" we would have a fall back on alpha ordering.
> >> Steps with "jstorder" = null would be executed last - so there is no
> need to
> >> upgrade. To give the user feedback about ordering in pgadmin, the steps
> >> could be ordered the same way in tree view and steps tab in job
> properties
> >> dialog. We could also add the jstorder-column to the list view.
>
> What do others think? I'm still not convinced this is necessary - and
> it certainly will become inconsistent with triggers.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>