Find out who Last Modified or Changed a Job
search cancel

Find out who Last Modified or Changed a Job


Article ID: 129004


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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?


Release: All Supported
Component: ODENV


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