SAS VA 7.4 Db2

[SAS_1001]

I'm wondering as to how to automate db2 queries in SAS VA.  I'm directly connecting to DB2 from SAS VA and joining the tables, aggregations, derivations, etc.  I need to automate this process.  How can I automate this process to run on a daily basis to bring DB2 data into LASR directly ?

[SASKiwi · Accepted solution]

Check out the scheduling capabilities in SAS VA:

http://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#p1ddpa5p0q2x28n1hgkex...

Personally I prefer to schedule jobs in VA from SAS Management Console as that is where you can also schedule non-VA batch jobs.

[SAS_1001]

Thank you. That helps !