SNLBanker - Restart the Daily Job

 Printable version:

Knowledge Base - SNLBanker Restart Job.pdf

Download PDF • 157KB

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.