JackGun05
JackGun058mo ago

how to copy a db using cronjob?

Hi, if we want copy some data from a db to our db via cronjob in the night for multiple user from our app, how works for the apicall and api authentication and how work for start cronjob for different users? some example?
2 Replies
JackGun05
JackGun05OP8mo ago
same help?
Luis
Luis8mo ago
Hi @JackGun05, one option would be to use the Schedule cron trigger for this (https://docs.buildship.com/trigger-nodes/scheduled-cron). Then depending on which database provider you are using you can use one of the database nodes BuildShip provides to copy the data for example postgres or mysql. To handle the job for different users you would need to have some branching logic in you workflow relative to some unique identifier for your users.