Thanks, Pierre. Interesting that we can call db functions from sqlviews. It's definitely an option I can try if I go with sql statement.
As management point, it would be easier to manage than putting the sql statement in shell command ( psql --- ). On Sat, Nov 28, 2015 at 11:59 PM, Pierre Dane <[email protected]> wrote: > so I suggest using cron with curl to call the sqlview > > On Sunday, 29 November 2015, James Chang <[email protected]> wrote: > >> Hi, >> >> In DHIS Server, we are trying to create a scheduled task that checks >> events and update some data in events. >> >> We like to avoid using database scheduler (like pgadmin III PgAgent) >> >> That leaves us (We think) with: >> >> - cron job with shell script using database sql comments (in file) >> - cron job with java executable (and Web API calls within Java) >> >> >> We prefer to do this using Web API. >> >> Does that mean 'cron job with java executable' is the only choice we >> could have for our operation? >> >> Any suggestion on other methods that we could use to set up a 'Web API >> data checking/updating' scheduled task? (If there is, could you also >> provide us with example?) >> >> Thank you. >> > > > -- > *Pierre Dane* > > Jembi Health Systems > Software Development Manager > tel: +27 (0)21 701 0939 > cel: +27 (0)83 680 8274 > email: [email protected] > web: www.jembi.org > > > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
