One of the unseen killers of data insights is stale data. In many instances, this comes from an unavoidably slow refresh rate or dead csv files that have to be manually updated. But sometimes stale data can sneak up on you even when you think you have automated your refresh. In SQL Server Management Studio, jobs can be used to facilitate the automated refresh processes through stored procedures and other scripts that are scheduled at specified intervals or triggered by alerts. Unfortunately, once they are set, it is not a guarantee that jobs will always run. Due to a default setting in SSMS, SQL Server Agent is set to turn on manually, not automatically after a system restart. The result: stale data.
The Solution: Automatic Start up for SQL Server Agent
Step 1a - Navigate to Services in your computer:
Open the start menu on your computer, right click on the Computer tab, and select Manage. Note: You will need to have administrator privileges to make changes to the services portion of your computer.
Step 3 - Select correct Startup Type:
In the General Tab, click on the Startup type dropdown and select automatic. Click OK and exit out of the dialog box. SQL Server Agent will now start up automatically.
Step 4 - Ensure Automatic Restart in SQL Server:
Open SQL Server Management Studio and right click on SQL Server Agent and select Properties. Select (if they are not already) both checkboxes shown above and click OK.
Step 5 - Enjoy your refreshed data!
By Michael Stead
Posted by admin