Data Collection parameters (relative/fixed combo)

[eamoncampbell]

Is there any way/workaround to arrange for job data collection parameters using a (fixed start date)/(relative end) combination?

It does not appear to be possible to configure the collection parameters as with the mock-up above but is there any way to achieve this outcome or similar?

Any input appreciated.

[Geoffrey2 · Accepted solution]

There does not appear to be an out-of-the-box way to do that.  

You could try setting it to Fixed.   Then using a scheduled job to update the End date each day before the data collector executes.

[eamoncampbell]

Thanks Geoff,

Any suggestions/pointers as to how about setting up the scheduled job to update the end date (is there scripting involved here)?

[Geoffrey2]

If your Data collector runs at 9am every morning, then create a Scheduled Script Execution that updates the one "relative" date that you need every day at 8am (or something).   Just make sure you test it in case you get issues with different time zones, etc.

[eamoncampbell]

Excellent - we will try this out Geoffrey!

Looks to be working a treat Geoffrey - In this particular case using the 'Execute Now' button withing the Update Fixed End - Scheduled Script Execution page. Just one modification was required to your script to gdt.getDate().getDisplayValue() as gdt.getDate() was succeding to only clear the score_fixed_end field.

Thanks again