Speed Up the Processing Time of RunETL

Issue #

  • RunETL process is taking too long to process than usual.

Environment #

  • Windows
  • SQL Server 2012 up

Resolution #

  1. Back up FIRST the the dbo.time script in a text file. Navigate to OpeniT > Views > dbo.Time > Script View as > ALTER To > New Query Editor Window, as shown below.
  2. Drag the timefix.sql file (script icon above) to the SSMS application, then select Execute.
  3. Afterward, you may optionally force-execute RunETL, or wait for its next scheduled execution.