I'm currently in the same boat that I wish there was something better
for running jobs against Postgres than pgAgent.
Using pgAdmin to manage my numerous jobs isn't the best experience
i've ever had to say the least, but it does work. No other tool I
have used will manage pgAgent jobs.
I worked to alleviate some of my pain with pgAgent, by re-writing the
entire agent portion: https://github.com/GoSimpleLLC/jpgAgent
It uses the same schema as pgAgent, and you can manage it with pgAdmin
just the same, it just has way more features, and has been extremely
stable for me.
One thing I have wanted to do for a while, is to write an entire
alternative job scheduler / management tool separate from pgAdmin
which will be dedicated to just that single purpose.
I put in a good bit of work on that, but haven't had time to go back
and get it to a point where I can actually release it:
https://github.com/Tostino/pgAutomator
The goal is to have a tool much closer to what is available for SQL
Server, or Oracle compared to what we have today. The backend stuff
is mostly working, I just need to find time to write a frontend to
manage it.
Anyways, sorry for a bit of rambling. My main point was that this is
something that has been a personal pain point, and I haven't found
anything I liked better up to this point in time.
I'm slowly working on remedying that, but until the time my
alternative is ready, i'm sticking with (j)pgAgent, and pgAdmin to
manage it.
Thanks,
-Adam
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
