I actually meant pgAgent. Sorry for the confusion. It looks like we will be looking at cron jobs, while dhis apps gain some sort of scheduling capabilities.
Rodolfo Meliá +44 777 576 4090 | +1 708 872-7636 Please ignore any typos on this email sent from my mobile, probably written while I was at the park with the kids, at the airport walking to the gate, or sleepless (although exhausted). Grammatical faults? I'm sorry- I do my best > On 1 Oct 2013, at 15:19, Bob Jolliffe <bobjolli...@gmail.com> wrote: > > Well by taking it out of the jvm we do remove some functionality .. mostly > access to all the dhis2 beans and whatever is not immediately available > through the api. > > But it is quite straightforward to run a standalone camel instance which > talks to dhis2 via the api. > > Unfortunately there are always some times when you have to resort to the > database :-( If you only want to schedule some sql script to run then I > agree with Jason that a cron job which pipes the script to psql (not pgadmin) > can often suffice. > > If you find yourself (in addition to just scheduling), also doing more > complex data transformations and the like then it can make sense to have an > integration engine like camel - which also has a jdbc endpoint. But again, > if the only thing your camel context is doing is running the sql then it > really doesn't need to be in the dhis.war. Thats really why we have removed > it. You can do the same thing with camel (and/or other tools) without having > it loaded in the virtual machine. > > >> On 1 October 2013 15:04, Jason Pickering <jason.p.picker...@gmail.com> wrote: >> Nothing against Camel, but not sure what the issue with executing a task on >> the database might be. Just wrap it up as a shell script and schedule it >> with cron. >> >> Maybe I am missing some security issue there, but we use this approach >> extensively for this type of task. >> >> Regards, >> jason >> >> >> >>> On Tue, Oct 1, 2013 at 3:59 PM, Rodolfo Melia <rme...@knowming.com> wrote: >>> Hi - we were thinking about using Camel for automating certain jobs that we >>> want to run every 24 hours (update some Data Elements based on some custom >>> calculations that cannot be run as indicators). We ruled out pgAdmin >>> because we feel is too insecure. Now that camel is out, how can we schedule >>> task to run every day? Do you plan to have a scheduler for an app, so >>> certain routines can run on the basis of a schedule? >>> >>> Rodolfo >>> >>> Rodolfo Meliá >>> Principal >>> rme...@knowming.com >>> www.knowming.com >>> +1 708 872 7636 >>> +44 777 576 4090 >>> Skype: rod.melia >>> >>> >>>> On Tue, Oct 1, 2013 at 11:26 AM, Bob Jolliffe <bobjolli...@gmail.com> >>>> wrote: >>>> We have decided to remove the camel integration module from the dhis2 war >>>> file in the next release. >>>> >>>> As the web api has matured it is now more feasible to run the likes of >>>> apache camel or mule or similar software as external clients of the api. >>>> >>>> Regards >>>> Bob >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : dhis2-devs@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-devs@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
