Solved: Re: SAS VA 7.4 Db2 - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Quartz | Level 8

Quartz | Level 8

SAS VA 7.4 Db2

Posted 02-03-2018 01:19 PM (1228 views)

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions

PROC Star

Re: SAS VA 7.4 Db2

Posted 02-03-2018 09:02 PM (1299 views) | In reply to SAS_1001

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.

View solution in original post

2 REPLIES 2

PROC Star

Re: SAS VA 7.4 Db2

Posted 02-03-2018 09:02 PM (1300 views) | In reply to SAS_1001

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.

Quartz | Level 8

Quartz | Level 8

Re: SAS VA 7.4 Db2

Posted 02-05-2018 11:05 AM (1154 views) | In reply to SASKiwi

Thank you. That helps !