SQL job to run Check Links stored procedure

(0) Share

Report

Posted on by DebN

3,954

Is it possible to schedule a SQL job to run that will execute a stored procedure to run Check Links on the Sales Transaction Work tables? If so, what is the name of the stored procedure for the SOP work check links?

*This post is locked for comments

All responses (2)

Answers (1)

DebN 3,954 on at

Like (0)

Report

RE: SQL job to run Check Links stored procedure

Hi Mahmoud,

Thanks for your input. We'll look into going with a macro instead.
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: SQL job to run Check Links stored procedure

Although checklinks is a collection of stored procedures that are run against the database to check specific tables integrity, it operates under the "umbrella" logical tables relations which exists in the application dictionary. Although this might be "theoretically" possible, to track down the process flow and how stored procedures operates, I would recommend another easier approach to fulfill your target of scheduling this maintenance utility to run on a frequent bases.

I propose another solution, record a macro starting from opening Dynamics GP, logging in and then opening the check links series to be run. This file can be stored on your windows server desktop. Now to schedule this file to run on a frequent bases, you may consider the windows "Task Scheduler" which gives you the required flexibility to run the file on demand.

Your feedback is highly appreciated,