Batch job

[Former Member]

Hi,

I have requirement to schedule the batch job for report,

Job should be run weekly and it should be download to network drive in local PC,

In Report, we have input as date, and the date should be the last week date,

for example: if job is running on Saturday(25th June) then the input date should be 18th to 25th June, similarly the same job will run on 2nd July and date should from 25th June to 2nd July and so on....

So input date is varies,

Please help how we can set up the variant.

Regards

Vanraj

[Former Member · Accepted solution]

Hi,

This can be done in the variant used in the job. Please go to the variant attributes from report that you are using. And for the date field in the Selection Variable input "D" and in the Name of the variable choose Current date -xxx, currentdate + yyy and then enter the number of days that you want to deduct or add and save the variant.

Also you can use the variable current date +/- workdays to achive the same.

The next time the job runs it will take the date as per the settings given in the variant and update the dates accrodingly.

Regards,

Sampat

Edited by: Sampat Vijay Sadalge on Jun 23, 2011 1:07 PM