Page History

...

1. 1. Go to the Agent installation directory. 
   2. Find the unins000.exe uninstall file and run it. 
       

Download and install SQL Agent 3.0.

1. 1. Go to Integrations on the MSPbots app menu. 
   2. Find the SQL Agent and click the Config icon.
      
   3. Next, click the download icon for the MSPbots SQL Agent Client to start downloading the installer file.
      
   4. Locate and double-click on the downloaded installer.
   5. During the setup, select Automatic start and Create a desktop shortcut, then  then click Next. 
      
   6. Follow the prompts. In the last step, tick the Launch MSPbotsAgentService checkbox and click Finish. The window will automatically close when the service starts.
      
       

...

1. 1. Go to Datasets on the MSPbots app menu and click the New SQL Agent Dataset button. 
      
   2. When the New window appears, fill in the dataset Name and Description fields.
      
   3. Next, go to the Data Cleaning tab to show the Validate SQL section below. Select a database from the DB dropdown list. 
      
   4. Scroll down to the Validate SQL section, fill in the SQL field, and input your desired Sync Frequency in minutes.
   5. Click Confirm when done. This will show a preview of the data for your validation. You can customize or use the default character length for string type fields.
      
   6. Once you confirm the data is correct, click OK to create and save the dataset. The data will be synchronized in 10 minutes.

Save the logs and send the file to MSPbots Support Team.

1. Open the MSPbots Agent client and click the Save Log button on the upper right corner of the window. 
   Image Added
2. Click Confirm on the Tips popup that appears. 
   Image Added 
3. Next, select the location to save the logs, provide a filename, and click Save.
4. Send the file to support@mspbots.ai