- Mar 11, 2024
- 1 min read
Updated: Mar 15, 2024
Printable version:
Scenarios
When the daily load job fails due to a temporary condition it can simply be re-run after resolving the condition. The ETL is designed so that it can be run multiple times without creating data duplicates or anomalies.
Examples
“Core Not Ready” email alert when nightly processing on the core takes longer than usual
“Server not found” messages due to downtime or network issues
“XYZ file is missing”
Steps to re-run the Job
In SQL Server Management Studio (SSMS), browse your SQL Server in Object Explorer
Expand the SQL Server Agent section
Expand the Jobs folder
Right-click the failed job and select “Start Job at Step”
 |  |
Select either the step that failed (to save time) or Step 1 and click “Start”. You may close the window once it starts and it will continue to run.