-
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
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
- Confirm that a sql query/stored procedure can be added to the system outside of the release cycle
- Confirm that the sql query/stored procedure can be updated if needed
- 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
- Ensure that only read only queries are to be saved.
- Implement a validation to check for valid/long running queries (60 seconds)
- implements
-
CFAMX-10369 Forecast Import Dashboard & Notification (Query Mailer)
- Closed
1.
|
Review Test Scripts | Done | Soma Dixon (Inactive) |
|
|||||||||
2.
|
Deploy | Done | Gareth Leibbrandt (Inactive) |
|
|||||||||
3.
|
Functional Review with QA | Done | Colin Wyatt-Goodall |
|
|||||||||
4.
|
DIT | Done | Colin Wyatt-Goodall |
|
|||||||||
5.
|
Create new SQL tables | Done | Colin Wyatt-Goodall |
|
|||||||||
6.
|
Create data objects | Done | Colin Wyatt-Goodall |
|
|||||||||
7.
|
UI changes | Done | Colin Wyatt-Goodall |
|
|||||||||
8.
|
Update Service Layers | Done | Colin Wyatt-Goodall |
|
|||||||||
9.
|
Query Validation | Done | Colin Wyatt-Goodall |
|
|||||||||
10.
|
Dev Testing | Done | Colin Wyatt-Goodall |
|
|||||||||
11.
|
Create Test Cases | Done | Gareth Leibbrandt (Inactive) |
|
|||||||||
12.
|
Execute Test Case | Done | Gareth Leibbrandt (Inactive) |
|