Query maintenance s tmp deletables: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(Created page with "{{PAGENAME}} in Centralized data front end.accdb checks if any active rows in s_tmp table are not currently used, and might therefore be set to "inactive". Category:IT Support")
 
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{PAGENAME}} in [[Centralized data front end.accdb]] checks if any active rows in  [[s_tmp table]] are not currently used, and might therefore be set to "inactive".  
Query maintenance_s_tmp_deletables in [[Centralized data front end.accdb]] checks if any active rows in  [[s_tmp table]] are not currently used, and might therefore be set to "inactive".  
 
== Log ==
* 2022-08-10 - checked, no likely candidates for removal
* 2022-01-26 - created query, emailed Julie and Lisa if any can be inactivated
{{Todo
| who = Tina 
| question = _regular
* this should be done regularly, maybe every 6 months
| todo_added = 2022-01-26
| todo_action = 2023-02-10
}}
 
== Related articles ==
{{Related Articles}}


[[Category:IT Support]]
[[Category:IT Support]]

Latest revision as of 14:41, 2022 August 10

Query maintenance_s_tmp_deletables in Centralized data front end.accdb checks if any active rows in s_tmp table are not currently used, and might therefore be set to "inactive".

Log

  • 2022-08-10 - checked, no likely candidates for removal
  • 2022-01-26 - created query, emailed Julie and Lisa if any can be inactivated

_regular

* this should be done regularly, maybe every 6 months
  • added: 2022-01-26
  • action: 2023-02-10
  • Cargo


  • Categories

Related articles

Related articles: