Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • SCRUM Team:
      Globogym Purple Cobras
    • Story Points:
      3
    • SOW (Time Tracking) Project:
      44918
    • Work Type Classification:
      Sustaining

      Description

      As a support team member I want to be able to upload a SQL Query/Stored Proc that can be scheduled to email results on a daily basis so that I don't have to run it manually

      Notes

      • There are often times when we run into an issue, and the summer team have to execute a SQL query/Stored Proc on a daily basis and share the results
        • Long term we address the issues that result in this type of activity, but there is an interim period that should really require a user to get manually get the results on a daily basis
        • This could be achieve by using a SQL Agent task, but ops prefer that we don't follow this route
        • As such, we are looking for a way within the application (InFORM or Server Manager) to upload the query, schedule it, and have the results be emailed out
      • In this particular case, the query below is being executed on a daily basis and the results are manually sent out each day 
      • There Should be a tab in server manager where the details are saved.
      • Corey suggested that adding something to Server Manager might by a good option, there is already task scheduling available

      Acceptance Criteria

      1. Confirm that a sql query/stored procedure can be added to the system outside of the release cycle
      2. Confirm that the sql query/stored procedure can be updated if needed
      3. Confirm that there is a way to configure a list of email addresses, that will be used as the recipient list of the results of the sql query/stored procedure
      4. Ensure that only read only queries are to be saved.
      5. Implement a validation to check for valid/long running queries (60 seconds)

        Attachments

        1. image-2020-07-07-10-14-08-189.png
          31 kB
          Colin Wyatt-Goodall
        2. image-2020-07-07-10-14-08-189.png
          31 kB
          Colin Wyatt-Goodall

          Issue Links

          There are no Sub-Tasks for this issue.

            Activity

              People

              • Assignee:
                will.englefield Will Englefield (Inactive)
                Reporter:
                Colin.Wyatt-Goodall Colin Wyatt-Goodall
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 27h Original Estimate - 27h
                  27h
                  Remaining:
                  Time Spent - 28h Remaining Estimate - 4h
                  4h
                  Logged:
                  Time Spent - 28h Remaining Estimate - 4h
                  28h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.