master jobs list from Redwood CPS

[Former Member]

Hello Experts,

I need to take master list of all job definitions and job chains from Redwood CPS. Please help me how can i get them. I am using M33 Version.

[nanda_kumar21 · Accepted solution]

1. Navigate to Definitions-->Reports-->right click and select new report.
2. Select option Object Definition Query: select * from and select JobDefinition from the drop down.
3. Navigate to Columns and click add all columns.
4. You can do selections and sorts if you want.
5. You can try the preview tab, but i wont advice it because it is going try pull all job definitions from the DB.
6. Save and close.
7. Submit System_ReportRun job, select the filter you created, select the output as csv.
8. Once the job completes, you can download the CSV file.
9. Repeat the procedure for Job Chains.

NOTE: in Step 2, you can play with the SQL query to obtain job definitions only created by you and not system job definitions.

Thanks

Nanda

[Former Member · Accepted solution]

Thank you very much Nanda

Regards,

Praveen