Saviynt Forums

Sivagami · ‎05/16/2023

Hi Team,

Auditors have requested us to provide the details of last modification date of a job trigger with the details as to who modified the trigger. Could you please share a query to identify the same?

-Siva

dgandhi · ‎05/16/2023

Hi Siva,

Please refer qrtz_triggers table JOB_DATA column. Only problem is in JOB_DATA , the data will be stored in blob format but it will provide with the username of the user who made changes in the trigger.

Thanks

Thanks,
Devang Gandhi
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

rushikeshvartak · ‎05/16/2023

Use saviynt in built feature "Saviynt Audit trail"

Regards,
Rushikesh Vartak
If the response is helpful, please click Accept As Solution and kudos it.

Saviynt Forums

Extract Last Modification Date of Job Trigger