SQL Auto Call Roll Forward Utility

This utility creates the SQL Auto Call Roll Forward job that works in conjunction with the Setup Options in Service Management (Auto-Roll Calls Forward and Use Auto-Roll SQL Job). See Auto-Roll Calls Forward in Choosing Service Options for additional information. The SQL Job evaluates the number of Dynamics companies for which Signature Service Management is installed. For those companies, the Create SQL Job process will create the Auto-Call Roll Forward SQL job which can then be configured and scheduled, as needed. 

1. Select Signature Utilities > File Maintenance Utilities > Signature Utilities > SQL Auto Call Roll Forward.

2. In the SQL Auto Call Roll Forward window, select Create SQL Job. 

• If the SQL Server Agent is running, the following message displays "SQL Job "Signature Auto-Roll Calls Forward" was created. This job has a separate step for each company database. Each step (each company) will run the procedure SMS_Auto_Call_Roll_Forward if the company's setup option is set to on. (Auto Roll Calls Forward and the Use Auto-Roll SQL Job options must both be marked in Setup Options.)

• If the SQL Server Agent is not running, the following message displays: "SQLServerAgent is not currently running so it cannot be notified of this action." This indicates that the job was not created.

If you create any additional companies after running this utility, and mark the two Auto Roll options in Setup Options, you can run the utility again by coming back to the window and selecting Update SQL Job. This will not affect the previously-created SQL job other than to add a new step. Additionally, if you want to stop the SQL Auto Call Roll Forward Job, you can unmark the Use Auto-Roll SQL Job option in Setup Options. Microsoft Dynamics GP > Tools > Setup > Service Management > Module Setup > Service Options.