Issue #
- RunETL process is taking too long to process than usual.
Environment #
- Windows
- SQL Server 2012 up
Resolution #
- 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.
- Drag the timefix.sql file (script icon above) to the SSMS application, then select Execute.
- Afterward, you may optionally force-execute RunETL, or wait for its next scheduled execution.