Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

To be honest, I and others are spoiled by Microsoft's SQL Agent. We'd really like to keep properties of SQL Agent : the features, the usable GUI.

I searched serverfault for an evaluation of different CRON GUIs / Scheduling agents, but really didn't find quite what I was looking for. So, I'd like your input.

  • What's worked well for you, been usable.
  • I'd especially like to hear from someone who has approached it from my point of view.
  • What is your experience with the below 3 options?

Seems like our options are so far are:

  • PgAgent - seems just the ticket. Unfortunately, it doesn't work well with Greenplum. Also, it looks like it might be somewhat abandoned - the last release date was some time ago. But it might just be that it's so well done, it hasn't needed new releases.
  • Job Scheduler,, which on first glance, seems to fit pretty well. But I'm a bit concerned that it might have complications in order to generate consulting revenue. It also just doesn't 'feel' like SQL Agent, reading the docs, many of the concepts feel foreign. On the plus side, it certainly looks to be kept up.
  • Cron

Thank you in advance!

share|improve this question

If you have the option of running the central scheduler on a Windows box, have a look at JAMS by MVP Software. It has agents for just about anything you could ask for. We evaluated it and it is quite powerful. The scheduler is very much Windows-centric, though, so I'm not sure it'll completely fit in your environment and I admittedly don't know how well it integrates into Greenplum...

share|improve this answer
Yeah, they at least have a great website / demos. I'll have to look into their pricing. – MaasSql Apr 15 '11 at 15:36
JAMS is more product than I'm looking for. If I had the budget, I could justify looking deeper into it. – MaasSql Apr 18 '11 at 18:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.