SAP Knowledge Base Article - Public

2238185 - How to Create an Ad Hoc Report Export Job Schedule using the Last Modified Date and Expression Builder

Symptom

You want to create a reoccurring job schedule which will provide all the Job Requisitions modified in the last week.

This KBA will show how you can create such job using the Expression builder parameters.

Requirements:

  • Report available (Ad Hoc Report)
  • Admin User with Provisioning Access

Steps:

  1. Create an Ad Hoc report based on the Recruiting V2 Secured domain
  2. Define a filter on the Last Modified Date field

 ad hoc filter.png

  1. Create a Job via provisioning Managing Job Scheduler > Manage Scheduled Jobs > Create New Job
  2. Enter the Job Name, Owner, Type and Parameters then Edit the runtime filter

new job exp builder.png

  1.  Select the desired parameters via the expression builder. In this case, Expression ${today}, Operator '-' and Pattern 7 Days.

2015-11-02_15-24-47.png

  1. Fill in the remaining information in order to be able to submit the job successfully.
  2. The Job is successfully completed and depending on the job configuration you should have an output file (csv or xls) in your FTP server location with the Job Requisitions data, according to the Last Modified' field, for the last week.

Note: In case of recocurring jobs you may want to set the start date on the same day you want the job to run on a weekly basis.

Environment

  • SAP SuccessFactors HCM Suite
  • Ad Hoc Reports
  • Job Schedule

Keywords

job schedule, expression builder, job parameters, adhoc report schedule , KBA , expression builder , job schedule , report schedule , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Suite all versions

Attachments

ad hoc filter.png