How to export Job details in redwood

[Former Member]

Hello experts,

Can anyone tell me how can I export the details of all the jobs that are in scheduled/saved/on hold status in Redwood.

Need to create an excel for all the jobs.It will be more tangible if there is a way to extract jobs via redwood than doing it manually.

Regards,

Sumit

[nanda_kumar21 · Accepted solution]

Yes, you can.

1. Open the Job Monitor.
2. Right the top of the Monitor tab and then select Filter-->New Filter.
3. Select the queries that fit your requirement (Like jobs in specific status)
4. Save it with a name.
5. Navigate to Definitions-->Reports
6. Create a new report
7. Add the filter in query filter, provide a name.
8. Select the columns tab and add the ones you need
9. Click save and close.
10. Right the click the report, submit report job.
11. Select the output as CSV.
12. Once job completes, download the csv file from job output.

For more details refer the reports/filters section of the administration guide of your CPS build.

Thnaks

Nanda

[Former Member · Accepted solution]

Hey Thanks Nanda,

also Can we set up an alert for redwood so that we can get an alert when redwood is down or not working.

Regards,

Sumit

[nanda_kumar21 · Accepted solution]

You can create a job chain with step 1 being the System_Report run and second step System_mail_send, and set the JobFile parameter of System_mail_send as * and Relative Job as Step 1, Job 1.

Thanks

Nanda

[former_member1244799 · Accepted solution]

This message was moderated.

[h_carpenter · Accepted solution]

Hi Ramana,

It would be better to ask here, as other people will see your questions and the answers.

You can also hire SAP/Redwood consultants to handle the implementation details for you; you should contact your SAP account representative for details.

Regards,

HP

[Former Member]

Hi Nanda,

thanks for the reply it was really helpful.

Can you please tell me how can I create a time window where a job should run on 2nd workday of the month but the job should include public holidays.

Regards,

Sumit.