Stored Procedures

Stored Procedures in MS SQL are used rarely and only in special cases.

fnFileStatus

• [sp_CleanupFileStatusRecords]
  • Cleans up old upload logs (for things like percentages complete) that are informative during the process, but can be removed later.
  • Parameter: @AGE
    • Optional
    • Default: 90
  • Triggered by fnFileStatus at 1:00am every day