executing a query daily

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • akilageethal
    New Member
    • Oct 2007
    • 6

    #1

    executing a query daily

    I want to get a query executed everyday at a perticular time. What is the way of doing it??
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    Originally posted by akilageethal
    I want to get a query executed everyday at a perticular time. What is the way of doing it??
    Write a script and use cron.

    Comment

    • akilageethal
      New Member
      • Oct 2007
      • 6

      #3
      Originally posted by rski
      Write a script and use cron.
      I want to get it done with a query.. Like schedulars in oracle.. In postgre sql is there a similar thing to schedulars in oracle..

      Comment

      • rski
        Recognized Expert Contributor
        • Dec 2006
        • 700

        #4
        Originally posted by akilageethal
        I want to get it done with a query.. Like schedulars in oracle.. In postgre sql is there a similar thing to schedulars in oracle..
        maybe try to use pgAgent

        Comment

        Working...