1) Schedules are not site specific but are server-wide. Really not specific to a particular site. Also please note that Site Administrators cannot create schedules.
2) Restrict the timeout only for manual jobs , I have not seen anyone doing this and I don't think there is an easy way to do the same.
OR (If you can )
Don't give them access instead let someone else do on behalf of them (Owner / Administrator )
refreshextracts workbook-name or datasource-name
Performs a full or incremental refresh of extracts belonging to the specified workbook or data source.
This command takes the name of the workbook or data source as it appears on the server, not the file name when it was published. Only an administrator or the owner of the workbook or data source is allowed to perform this operation.
tabcmd refreshextracts --datasource sales_ds
tabcmd refreshextracts --project "Sales External" --datasource sales_ds
tabcmd refreshextracts --workbook "My Workbook"
tabcmd refreshextracts --url SalesAnalysis
Please mark the answer as HELPFUL/CORRECT if it really helped you so that it can help others as well .
Im aware that the schedules are Server Wide. Which is why I mentioned, that most of the extracts on the server (across sites) run overnight.
The site administrators are informed about the schedules.
What we're trying to achieve here is to first limit the number of manually triggered extract jobs using the "refresh now" option.
We do inform that the site administrators trigger the refresh extract jobs and also to make use of the Schedules, but the challenge here is
- Since the sites are for a department. Some site admins may not actually be involved in a project and grants the refresh rights to the publisher. Now, multiply this by the number of sites and publishers, you get an idea of how many people can actually trigger manual jobs.
- Prioritization of the jobs by a site administrator would work best when we have a limit of the jobs run per site. This way, we can actually ensure that not more x number of jobs will run in a day. Right now, there isn't anyway to see this.
- Users often refresh data as part of development. Problem is, we notice extracts run to the full timeout and notice
- Joins weren't properly configured
- Filters weren't set properly.
What I have explained above are just some of the common issues we notice. Hence my second point if we have a time out limit set specifically for the manual jobs.
We have a self service model established where the users/site admins are expected to handle all things pertaining to the site. But this freedom manifests itself as a server wide problem which is where we need some stability to ensure everyone gets access. So, as a server admin, we'd like to get some control and let the users get exactly what they want.