SQL Stored Procedure To Run Dynamics Utility Nightly

(0) Share

Report

Posted on by Community Member

Hello,

We would like to be able to have a Utility run from a stored procedure on a nightly basis after the database backups. Does anyone have anything like this working for them? If so, it would be great to have your example to work from. It can be a generic case.

Background: This is specifically for a Utility from a Dynamics Partner, WennSoft, in their Job Cost Module. (They are not as much help, hence the request here). Sometimes there is a discrepancy in the "Job Status" window between the summary data and the detail in the drill down. We've been told to routinely use the Utilities "Reconcile Jobs" and "Recreate Summary File", in that order. Before doing this you must backup the databases. It would be nice to have all this happen nightly, after the nightly backups, via a stored procedure or something.

Best,

JPR3

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

DinB 3,944 on at

Like (0)

Report

RE: SQL Stored Procedure To Run Dynamics Utility Nightly

You consider the Macro Method as described in following blog.

dynamicsgpblogster.blogspot.ca/.../how-to-schedule-dynamics-gp-to.html

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: SQL Stored Procedure To Run Dynamics Utility Nightly

Max has cleared the way, it has always been done using a Macro.

A similar case can be found as well on macro that will include a line for logging out

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: SQL Stored Procedure To Run Dynamics Utility Nightly

Thank you both. In searching for GP Macro information I did find a guide: http://www.turnkeytec.com/solutions/gp/gp-editions/step-by-steps/how-to-create-and-run-macros-to-perform-tasks-in-gp-2/

Was this reply helpful? Yes No