This utility works in conjunction with the Signature Setup Option to Auto Roll Calls Forward and the Use Auto-Roll SQL Job options (both options must be marked). Microsoft Dynamics GP > Tools > Setup > Service Management > Module Setup > Service Options.
- Choose Signature Utilities > File Maintenance Utilities > Signature Utilities > SQL Auto Call Roll Forward.
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." and 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.