You probably need the "tasks" table for this work, although I've never attempted to figure this out myself.
The entire schema of the workgroup is documented, however - sounds like you may not be aware of this.
Go here and you'll get the best documentation on the subject that is currently available: Workgroup DatabaseData Dictionary
Thanks for the answer. After review the link that you sent and the suggestion, it's seems like task table is only task done for the user, for example when you manually refresh a workbook that is saved as a RefreshExtractTask. I don't see if it's possible to link the workbook table with the schedule table, I think maybe is a error in the table design.
1 of 1 people found this helpful
Please give the dictionary a closer read:
schedules Records in this table define a schedule according to which certain regular tasks may be performed (see tasks table). They also indicate the next time at which the schedule will be triggered. tasks Serves to connect schedules with background tasks that should be run on that schedule. The schedule is defined in the schedules table, while the task is defined by type.
I'm pretty sure the relationship is indeed there, just not as "directly" as you are hoping. Look for a relationship between a workbook and task, and then between a task and a schedule.
Thanks Russell. I was reading wrong the output from Task table.