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 Accept As Solution and give Kudos to help others who may have a similar problem.

rushikeshvartak · ‎05/16/2023

Use saviynt in built feature "Saviynt Audit trail"

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Saviynt Forums

Extract Last Modification Date of Job Trigger