topic Schedule data pull from DB in Connectivity & Data Prep

Schedule data pull from DB

knight_rider2905 — Wed, 17 Mar 2021 07:50:08 GMT

I'm pulling data from db of last week every Monday, having start and end date in query. I want to schedule this activity so that manual intervention is not needed for pulling data.

I want to understand how we can use current date function to schedule this job or is there any other way to schedule this activity.

Re: Schedule data pull from DB

denisb — Wed, 17 Mar 2021 11:00:29 GMT

You can use today() as Date in your SQL .

For example:

LET currentDate = today();

SQL select * from myTable where date >= $(currentDate) - 7 days;

You can also use your current date from SQL Server and just schedule the Qlik Sense Task on every monday.