Activity Universe Query

other Auditor
1

I would like to understand if there is a way to distinguish between list of reports manually run vs scheduled reports

Pragna (BOB member since 2007-07-25)

2

Yes, you will need to distinguish on-demand vs scheduled report viewing by the EVENT_TYPE_ID in the auditor database. For example, here are some event types tied to scheduled activity:

327681 - Job successful. The object ran as scheduled
(or requested) and the job
completed successfully.

327682 - Job failed. The scheduled job did not
complete successfully.

327683 - Job failed. Job will be
retried by the CMS.
The scheduled job did not
complete successfully. The job
will be retried by the CMS at a
later time.

crystal01 :us: (BOB member since 2006-08-30)

3

thanks…that helped

Pragna (BOB member since 2007-07-25)