<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=134816313595691&amp;ev=PageView&amp;noscript=1">

RemoteRelief BLOG

Let's talk business technology...

All Posts
Reading Time: 2 minutes
 
Published on 3/4/20 5:27 PM

GENERATING THE JOBS RESULTS REPORT FROM THE REMOTELINK DATABASE

Introduction

The RemoteLink application has been a valuable tool in helping our customers automate day-to-day store operations reporting as well as data transfer and backend processing. Automating the operational data movement and processing only provides part of the solution. Providing an automated reporting process which consumes the data and provides it to systems administrators and management allowing organizations to have valuable insight into their operations.

RemoteRelief has working knowledge of the backend databases and has created a ‘utility’ that can be implemented with the RemoteLink sessions to generate a report for your overnight jobs.

What Do We Need?

The process is not a ‘one size fits all’ kind of thing and will vary from customer to customer. For example, there may be the need to see a job’s performance or the condition to see a specific time frame. It all depends upon the customer’s requirement. In order to accomplish this; you will need to have access to the SQL Server database from your RemoteLink application server. A RemoteLink session will need to be set up and configured to run the SQL Server script against the RemoteLink database. Generating a report only requires reading few tables so granting read access should be enough.

*The RemoteLink server must also have to have ability to run a PowerShell script.

How Do We Do This?

  1. A stored procedure will be created in the RemoteLink database to read and generate the data for the report.
  2. Another SQL Server script will be executed from the RemoteLink Server to execute the stored procedure for specific days.
  3. A PowerShell script will be created to run the SQL Script.
  4. A RemoteLink session will be required to execute the PowerShell script to generate the report in an HTML format (and email to specific user if needed).

Final Results

Generating the JOBs Results Report from the RemoteLink Database - finalresults

Need Help?

RemoteRelief has SQL, SQL Database, and RemoteLink subject matter experts (SME), who aid clients in setting up and automating these types of processes. If you would like more information, subscribe to our tech blogs. If you are interested in a demonstration or learning more about operational data movement, RemoteLink features, automation and reporting capabilities click here to speak with an SQL SME.

 

Enjoy this article? Don't forget to share.

 
Neeraj Mehta
Author: Neeraj Mehta
Senior Database Consultant at RemoteRelief: Enthusiastic technology team player with sound business acumen of retail and point of sale processes. Plan, develop, and implement IT solutions using SQL Server to deliver best experience for end-users.

Related Posts

SQL Server Database Maintenance using SQL Script.

Introduction Database maintenance is a critical function of a Database Administrator’s role. For example,...
Neeraj Mehta Reading Time: 2 minutes