https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-7-4-Db2/m-p/433823#M9322 <P>I'm wondering as to how to automate db2 queries in SAS VA.&nbsp; I'm directly connecting to DB2 from SAS VA and joining the tables, aggregations, derivations, etc.&nbsp; I need to automate this process.&nbsp; How can I automate this process to run on a daily basis to bring DB2 data into LASR directly ?</P> Sat, 03 Feb 2018 18:19:37 GMT SAS_1001 2018-02-03T18:19:37Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-7-4-Db2/m-p/433823#M9322 <P>I'm wondering as to how to automate db2 queries in SAS VA.&nbsp; I'm directly connecting to DB2 from SAS VA and joining the tables, aggregations, derivations, etc.&nbsp; I need to automate this process.&nbsp; How can I automate this process to run on a daily basis to bring DB2 data into LASR directly ?</P> Sat, 03 Feb 2018 18:19:37 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-7-4-Db2/m-p/433823#M9322 SAS_1001 2018-02-03T18:19:37Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-7-4-Db2/m-p/433929#M9323 <P>Check out the scheduling capabilities in SAS VA:</P> <P><A href="http://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#p1ddpa5p0q2x28n1hgkexlzh7v5y.htm" target="_blank">http://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#p1ddpa5p0q2x28n1hgkexlzh7v5y.htm</A></P> <P>&nbsp;</P> <P>Personally I prefer to schedule jobs in VA from SAS Management Console as that is where you can also schedule non-VA batch jobs.</P> Sun, 04 Feb 2018 02:02:07 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-7-4-Db2/m-p/433929#M9323 SASKiwi 2018-02-04T02:02:07Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-7-4-Db2/m-p/434228#M9329 Thank you. That helps ! Mon, 05 Feb 2018 16:05:20 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-7-4-Db2/m-p/434228#M9329 SAS_1001 2018-02-05T16:05:20Z