Apologies if this is a duplicate topic, I didn't see anything previously posted that satisfied this question...
I'm finding that users at my organization are creating new scheduled reports without careful consideration for possible set up issues that could block the queue (trailing semi-colons, special characters in the title, identical reports scheduled at the same time).
In a perfect world I would be able to tell everyone to be mindful and call it a day, but realistically not everyone will be willing to invest the time in making sure their set up is correct, and inevitably something goes sideways resulting in none of our scheduled reports getting sent for that day.
The "Reports and Schedules" screen is somewhat helpful in diagnosing the problem after it has already happened.. but I'm wondering if anyone has found a clever way to actively monitor newly scheduled reports? I'm envisioning something that alerts me that someone has created a new schedule in the database so I can review their set up before it's too late.
Could just be a manual review that I have to add to my daily workflow, but I'm trying to make my life easier where possible. Curious to hear others solutions.
Depending on the volume of new scheduled reports, you could always use SSMS to query gooesoft_report_schedule to check for any new scheduled reports.
I think this might be the best solution! I'm no SQL expert (more of a wannabe apprentice) , but I've cobbled together the following query that seems to be working.. does this make sense?
select * FROM gooesoft_report_scheduleWHERE as_of_datetime = CAST(GETDATE() As Date)
I don't think you will get any results from that query. You could try something like:
SELECT TOP 25 *FROM gooesoft_report_scheduleWHERE type <> 'o'ORDER BY create_dt desc
This is SO helpful, thank you for taking the time!!