-
Type:
Story
-
Status: Closed (View Workflow)
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
SCRUM Team:Brotherhood of Mutants
-
Story Points:3
-
Work Type Classification:Sustaining
Story
As a developer, I would like to split annual partitioning maintenance job into two jobs. One for update one for purge.
Description
https://fourthlimited.atlassian.net/wiki/spaces/RBCD/pages/2489319474/tbTransactionItem+Partitioning
we will be splitting the current task into two separate tasks to be able to create future partitions on a scheduled base.
qryMMS_tbTransactionItem_UpdateMonthlyPartitionScheme
other job(purge) will be still manual we do not want to do the purge process automatically.
Also according to Martin we should not do truncate anymore when deleting old partitions we should apply process switch process instead to make it working for RDS CDC process.
qryMMS_tbTransactionItem_PurgeMonthlyPartitionScheme
AC
- implements
-
CFAMX-9527 Database Partitioning
-
- In Development
-
1.
|
Create Test Scripts |
|
Done | Unassigned |
|
||||||||
2.
|
Deploy |
|
Done | Unassigned |
|
||||||||
3.
|
Functional Review with QA |
|
Done | Unassigned |
|
||||||||
4.
|
DIT |
|
Done | Unassigned |
|
||||||||
5.
|
Design Review |
|
Done | Unassigned |
|
||||||||
6.
|
Story Documentation |
|
Done | Caner Saritac |
|
||||||||
7.
|
Consult Caner/Martin |
|
Done | Caner Saritac |
|
||||||||
8.
|
Updating SP/ creating new job |
|
Done | Caner Saritac |
|
||||||||
9.
|
Dev Testing |
|
Done | Caner Saritac |
|
