Yes , we can do it using crontab if we want to automate it . I did it using crontab or if it's windows vm then using SQL agent jobs as it was database server.