Project overview

SSJAV is a web application built with React, Express, and MSSQL for the company's internal usage for SQL server Agent Jobs to allow employees to easily track server job's status and metrics and statistics. It also provides API endpoints for data integration with other on-premise application. Users can see schedule of agent job through daily calendar as well as in-depth details and graphs of each task of a job and each step of a task. While the application provides insight on which step of a task of a job took more than others and why it took that much time, it also provides non-technical users to track agent jobs that related to their work. Providing RESTful API also enriches the compability of the application with other on-premise application being easily integrate with other applications.

The Employees have works that depend on SQL Server Agent Jobs, they were getting notified on the status of agent jobs via email or SMS and only the authorized staff does have access to check SQL Server Agent Jobs through MS SQL Server Management Studio. Due to this half-blindness, being unable to check status of agent jobs via a user interface were having negative impact on the company's workflow. There was a need for an user interface that can be understandable by both technical and non-technical staff to track agent jobs and their tasks that are related to their works. Alongside with metrics and statistical information.