How can we help you today? How can we help you today?

Schedule Top Queries

Hi,

Is it possible to schedule a report of the Top Queries for a specific database?

Thanks
Jon
JonSko
0

Comments

9 comments

  • Adam W
    Hi Jon,

    The ability to run reports against particular servers is currently being developed. This would allow you to add, for example, the 'Longest running queries' tile to a report and schedule the report to run against specific server, but not a specific database. How far would this go to meeting your requirements?

    Thanks
    Adam
    Adam W
    0
  • JonSko
    Hi, yes that would be very helpful, what timeframe do you think this functionality would be released?
    JonSko
    0
  • Adam W
    We're hoping to release an initial version of it within the next couple of weeks (possibly in version 7.0.11)
    I'll update you when it does get released
    Adam W
    0
  • karl.oliver
    was this done we are running Version: 7.0.14.8072
    karl.oliver
    0
  • karl.oliver
    i see reports feature is in Version: 7.0.14.8072
    karl.oliver
    0
  • Adam W
    Hi,

    The ability to run reports against particular servers was released in version 7.0.11.

    More improvements to the reporting are currently being developed and we hope to release them soon.

    Thanks
    Adam
    Adam W
    0
  • JonSko
    Hi, maybe I missed something but is it possible to email the reports and/or schedule the reports to be emailed on a daily/weekly basis ect?
    JonSko
    0
  • karl.oliver
    - yes it is possible the reports to be emailed on a daily/weekly
    karl.oliver
    0
  • Adam W
    Hi,

    Currently you can schedule the reports to be emailed daily/weekly:
    https://documentation.red-gate.com/display/SM7/Scheduling+emailed+reports

    We are continuing to make improvements to the reporting, including making the scheduling more configurable.

    Thanks
    Adam
    Adam W
    0

Add comment

Please sign in to leave a comment.