Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below Two requirements.
In my Data base Daily jobs will run like below.
When I have extracted the jobs from database to QVDs on today 17/02/18 I have to extract only from today to last 8 days jobs from data base to QVDs i.e., Total 9 QVDs
1. A180209_AJOB
2. A180210_AJOB
3. A180211_AJOB
4. A180212_AJOB
5. A180213_AJOB
6. A180214_AJOB
7. A180215_AJOB
8. A180216_AJOB
9. A180217_AJOB
When I have extracted the jobs on tomorrow 18/02/18 I have to extract only from today to last 8 days jobs from data base to QVDs i.e.,
Total 9 QVDs
1. A180210_AJOB
2. A180211_AJOB
3. A180212_AJOB
4. A180213_AJOB
5. A180214_AJOB
6. A180215_AJOB
7. A180216_AJOB
8. A180217_AJOB
9. A180218_AJOB
How to automate this process please help me on this
Thanks in advance.
What's the script that you are using?
You can put a filter to take only latest 9 values from max date.
Since it is a set number of days, you can setup a FOR loop
Output:
FOR vDay = 1 to 8
ExtractDay=today() - vDay + 1
SELECT
*
FROM
"A" & ExtractDay & "_AJOB"
NEXT
One qvd/day or one qvd/all days?
For tomorrow is yesterday's data rebuilt or do you append?