Keep up to date with the latest information about Microsfot Dynamics GP through articles from the Perfect Image and azurecurve blog.
SQL Script to Notify When Upgrade Complete
August 9th, 2018 by Ian Grieve
This SQL script was written for a client with a large number of databases and which took a long time to update and they needed to upgrade through several versions of Microsoft Dynamics GP. The script checks for start and end times in the DB_UPGRADE table; when they match for all rows, an error is raised.
The script was scheduled using SQL Server Agent which was configured to send an email when the error was raised; this allowed him to know when part of the upgrade had completed and the next stage needed to be started.
/* Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). */ DECLARE @UpgradeComplete AS INT SELECT @UpgradeComplete = CASE WHEN COUNT(PRODID) = 0 THEN 1 ELSE 0 END FROM DB_UPGRADE WHERE start_time = stop_time IF (@UpgradeComplete = 1) /* throw error because all companies upgraded if <> 0, that means upgrade still running and nothing needs to occur */ RAISERROR ('GP 2016 upgrade complete; next stage needs to be started',11,1)