Creating a Scheduled SQL Server Job to Archive Work Notification Data

Summary

This article explains how to create a SQL Server Scheduled Job that processes and archives Work Notification data by executing a stored procedure. 

It provides instructions for creating the Work Notification archive procedure named DbTools_Process_Work_Notifications in the Analyst database. It also outlines the steps to set up a scheduled job in SQL Server to execute this procedure according to a desired schedule.

The primary purpose of this process is to reduce the manual effort required for cloud services to run individually for each database. You can also implement this process, provided they are using SQL Server Standard Edition or higher, which supports the creation of scheduled jobs.

Create DbTools_Process_Work_Notifications procedure 

Note: This procedure is automatically created during the database update included in the 
Analyst 9 MR 4 release.

If you are using previous version of Analyst follow the steps below:

1. Locate the DbTools_DataCleanup.sql file in the database folder.
2. Connect to SQL Server Management Studio (SSMS) using Analyst local user credentials.
3. Create a New Query window and paste the contents of the DbTools_DataCleanup.sql file.
4. Click Execute to compile and save the procedure to the Analyst database.
    

How to execute Stored Procedure

The DbTools_Process_Work_Notifications procedure is executed without a parameter value. 

1. Connect to SQL Server Management Studio (SSMS) using Analyst local user credentials.
2. Create a New Query window and paste the contents of the DbTools_Process_Work_Notifications.
3. Click Execute.
    

Create and Schedule Work Notification Archive Job   

1. Ensure SQL Server Agent service is running.

• Connect as Server Agent administrator.

• If the service is not running, click the Start button.
  If it cannot be started, check with the database administrator to ensure it is not disabled in Services.

  

2. Connect to database using (SA/Windows Authentication)
3. To create New Job, Right-click on Jobs and select New Job...
   
   
    
4. Under Job Properties, From the menu on the right select General and enter Name, Owner, and select Category.
   
   
    
5. From the menu on the right, select Steps and click New. Then under Command, enter the execute statement. 
   
   
    
6. From the menu on the right, select Schedules, then click New to open the Job Schedule Properties window. Fill in the schedule details as desired.
   
   
7. Click OK to close the Job.
   
    

Contacting SKF Technical Support Group

For further assistance please open a support case using the Technical Support group's self-help portal at www.skf.com/cm/tsg. Once your support case is submitted, a technician will contact you to begin working on your issue. For urgent issues we are available at these times by phone:

• Monday through Friday, 5:00 a.m. to 4 p.m. Pacific Time - 
  Phone: [phone] within the US or [phone] outside the US.
• Monday through Friday, 8:00 a.m. to 4:00 p.m. Central European Time - 
  Phone: [phone].
• Monday through Friday, 7:30 a.m. to 4:30 p.m. India Standard Time -
  Phone: [phone].