I referred this to set up a scheduled job and did everything as it mentioned(ran the pgagent.sql as well) I need a very simple task to run periodically. In the 'Definition' tab in the steps, few records are added into one of my table. How ever the statistics does not show it runs. snap shot of stats area . I use postgres 9.3. Please any one let me know where I take a look and any solution?

EDIT: Here is how I have schedule the job
enter image description here

  • What is the periodicity you've set? From the next run entry, one could guess it's one day, which is not passed yet since the creation of this job. – dezso Sep 26 '14 at 7:08
  • @dezso. Thanks for you attention. I have updated the schedule info. – Débora Sep 26 '14 at 7:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.