Find out who Last Modified or Changed a Job via a Lookup

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

In the 'Cancelled' state, the job cannot be resumed, therefore the information is needed to out to the user who cancelled the job.

We observed that our jobs to were all cancelled on the Scheduled Jobs page.

The Home > Reports and Jobs > Scheduled page does not contain information on who last changed the status of job, e.g. when a job was 'Processing' was selected and then set to 'Cancelled'.

How can we identify who cancelled the jobs and find out when the jobs were cancelled?

Environment

Release: All Supported
Component: ODENV

Resolution

Use the Administration > Lookups page to perform a quick lookup.

1. Click New to create a new lookup.

    2. Set Source = Dynamic. Save and Continue.

    3. In the Query tab: Enter the select statement needed.

In this example, the following SQL is used:

select id, name, status_code,
last_updated_date, last_updated_by from cmn_sch_jobs

   4. Click Save and Continue.

    5. In the Browse Window tab, enter the Preview button.

This will display the results of the table.

Additional Information

See also Jasper Reports cancelled after upgrade