1 of 1 people found this helpful
I don't have anything ready made for that, but I regularly use the TS Content data source I built to look at what content is refreshing extracts on a schedule. To do that you'd grab (Item) Name and Type and Extracts Scheduled. But it doesn't list which schedule(s) the item is refreshing extracts on.
The TS Background Tasks data source will show you the logic for looking up the schedule, even though it doesn't currently include it in the data. You can dig into the Custom SQL used there to see. Here's some of what it's doing, maybe enough to get you what you need, and I added the Schedules join in below. You're going to do something like:
SELECT * FROM tasks t LEFT JOIN schedules s ON t.schedule_id = s.id LEFT JOIN datasources d ON (t.obj_id = d.id AND t.obj_type = 'Datasource') LEFT JOIN workbooks w ON (t.obj_id = w.id AND t.obj_type = 'Workbook') WHERE t.type IN ('RefreshExtractTask','RefreshExtractTask')
Let me know if that gives you what you need!
*edit*: revised query, you don't actually need the background_jobs table for what you're after, I don't think.
You're too kind. You should have called me and idiot and tell me to do my homeworks
For some reasons, I had in mind that this method was unreliable (but I'm validating against what I see in the browser and it appears to be totally exact) and I was totally panicked and scared that I couldn't get that data, which is essential to what I'm looking to do.
I can now enjoy the reminder of the weekend in complete peace of mind