Update Audit Form Data Set
1. Job Identification
Section titled “1. Job Identification”- Job Name: Update AuditFormDataSet - Every 30 Minutes
- Database: SooperWizer
- Server: T3600-SERVERPC\DEV2019
2. Job Purpose
Section titled “2. Job Purpose”Business Objective:
Work in progress
Data Flow:
Quality.AuditFormSession → Processing (Enrichment & Aggregation) → dbo.AuditFormDataSetDependencies:
Work in progress
2.1 Job Steps (Execution Order)
Section titled “2.1 Job Steps (Execution Order)”- Step 1:
EXEC [dbo].[Sp_DataSetQuery_Quality_AuditFormReport]
3. Technical Details
Section titled “3. Technical Details”Permissions Required:
Work in progress
4. Job Steps
Section titled “4. Job Steps”Step 1: Update AuditFormDataSet
Section titled “Step 1: Update AuditFormDataSet”- Step Name: Update AuditFormDataSet
- Step Type: T-SQL Stored Procedure
- Success Action: Quit job reporting success
- Failure Action: Quit job reporting failure
Command:
EXEC [dbo].[Sp_DataSetQuery_Quality_AuditFormReport];Description:
Work in progress
5. Scheduling
Section titled “5. Scheduling”| Property | Value |
|---|---|
| Frequency | Every 30 Minutes |
| Frequency Type | Daily |
| Active Start Time | 00:00:00 (midnight) |
| Active End Time | 23:59:59 |
| Overlap Prevention | SQL Server Agent will not start a new execution if the previous one is still running |
| Retry Logic | No retries configured — the next scheduled run within 30 minutes acts as the effective retry |
6. Monitoring & Logging
Section titled “6. Monitoring & Logging”Work in progress
7. Data Processing Details
Section titled “7. Data Processing Details”Procedure Logic
Section titled “Procedure Logic”8. Business Impact
Section titled “8. Business Impact”Work in progress
9. Error Handling & Recovery
Section titled “9. Error Handling & Recovery”Work in progress
10. Dependencies & Integration Points
Section titled “10. Dependencies & Integration Points”Work in progress