JackGun05
JackGun055mo 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
JackGun054mo ago
same help?
Luis
Luis4mo 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.