AnsweredAssumed Answered

Reports/Reviews Scheduled Last Run

Question asked by Keshav Kumar on Mar 25, 2019
Latest reply on Feb 17, 2020 by Jamie Pryer

Like • Show 0 Likes0
Comment • 1

Hello Everyone,

We have a requirement where we have to check whether all the scheduled reports and reviews are run properly on the scheduled Dates.
Do we have any table or view from where we can fetch these details such as a last run date or something similar?

Jamie Pryer

Feb 17, 2020 1:44 PM

Correct Answer

Hey,

i think this table helps:

select * from V_LIST_REPORT_RESULTS

Also, check this out: Reporting on Reports....

and finally, this is some handy SQL to find the tables to use:

select * from user_views
where lower(view_name) like '%%'
order by view_name asc;

See the reply in context

No one else had this question

Outcomes

1 Reply

Jamie Pryer Feb 17, 2020 1:44 PM
Unmark Correct
Correct Answer
Hey,
i think this table helps:
```
select * from V_LIST_REPORT_RESULTS
```
Also, check this out: Reporting on Reports....

and finally, this is some handy SQL to find the tables to use:
```
select * from user_views
where lower(view_name) like '%%'
order by view_name asc;
```
Like • Show 0 Likes0
Actions