Do you need to make an immediate or occasional one-time backup of your Dynamics GP databases, or maybe run a SQL job that populates your BI360 Data Warehouse? Occasionally, you may be performing some month-end closing procedures, post a large, significant batch, or perhaps you are about to integrate a large amount of your Dynamics GP data into your BI360 Data Warehouse. It’s critical that you make a good set of database backups to use in recovery in case of a failure, in order to refresh your Dynamics GP data into your Data Warehouse without IT involvement. There are several ways you can create a one-time backup or run other SQL jobs, like refreshing your Data Warehouse for month-end reporting. Here are some easiest ways, with some of the tools most people are familiar with:
- Use the Dynamics GP Interface to back up a single database – requires you to log into GP on the SQL Server.
- Use the SQL Server Management Studio to back up a single database or run SQL job – requires you to have SQL Server Management Studio loaded on your workstation; not normally used by most accountants.
- Use the SQL Server Management Studio to back up all databases or run SQL jobs – requires you to have SQL Server Management Studio loaded on your workstation; not normally used by most accountants.
The above methods were the only way, until now. Introducing KTL Solutions’ Jobs Manager for SQL Server – the SQL Server jobs manager for the non-IT person.
KTL’s Jobs Manager for SQL Server is a standalone, web-based tool that allows the end users to easily maintain SQL jobs without having to go through the SQL Tools. The users don’t necessarily have to have an understanding of SQL Server Management Studio and they don’t have to get IT involved in the process. The application allows for disabling, enabling, and running jobs. It utilizes Windows authentication and is hosted under IIS. The filtering can be applied in the web.config file to include all SQL jobs or be filtered by default job name returned in the Jobs Manager website. The web.config file also controls security access to the Jobs Manager website.
BARRY CROWELL, MBA |BI/EDW Solution Architect
Barry uses his expertise to lead and teach a team of GP consultants to assure our solution scoping, architecting, and delivery meet and exceed the customer’s expectations. He helps clients analyze their current business processes and provides them with process improvements. He has performed implementations as the lead consultant and end-user project manager. Barry has over 20 years of experience working in accounting and the Microsoft Dynamics GP industry. He also possesses a bachelor’s degree in accounting and business administration from Black Hills State University and a master’s in business administration from La Salle University.