Hello @aswinrahul_madu,
could you already give a look to the Reload-on-start feature? https://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n1s2hnpd892n7fn1dp18x2xgffel.htm
Also, interesting to know, Autoload can help you to automatically load data, if you just drop the final dataset in the autoload folder https://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n0nm6qjzfz4eban1237qqrcmxz0j.htm
Besides those options, Your queries can be sent to be scheduled in your OS http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p1ddpa5p0q2x28n1hgkexlzh7v5y.htm
This means, there will be a scheduled task in your OS scheduler (Windows Task scheduler or cron/at), and you can set triggers in those scheduler. For this last functionality, I would ask support from your system admins.
Hope it helps.
Kind regards,
Juan
... View more