The Client
As a leading global asset management firm worth 20+ Billion USD, our client employs a deep value, credit-intensive approach across its investment platform. They specialize in value-oriented special situation investments. However, the client’s current process for executing, monitoring, and resolving issues related to their SQL Server agent jobs was hindering their ability to reach their maximum potential.
Challenges Faced by the Client
The client encountered multiple challenges related to their SQL Server agent jobs, which are critical to their business operations. One of the main difficulties was the need for users to connect to individual servers manually to execute, monitor, and troubleshoot jobs, leading to a lack of centralized control and visibility.
Another challenge was that creating or replicating new jobs required the creation of every step manually from scratch, leading to time-consuming and error-prone processes. The client did not want to grant the users too many permissions or access to SQL Server Management Studio, making it difficult to configure user rights and access controls.
Additionally, users lacked real-time insights into job status, making it difficult to address failures promptly. This led to longer debugging times and decreased productivity, which had an adverse impact on the client’s overall business operations.
Solutions
UBTI, with certified and experienced professionals in software development, streamlined the firm’s processes. To address this challenge, we provided an innovative solution that allowed our clients to easily configure, monitor, and manage their SQL server agent jobs across multiple instances. We developed an intuitive Angular web application that offers a centralized portal for job configuration, monitoring, and management. The user interface of the application is designed to be user-friendly and easy to navigate. Our solution typically have a well-organized and easy-to-navigate interface and efficient workflows that make it easy for users to complete tasks and achieve their goals.
Our solution provides an at-a-glance overview of the job environment, making it easy for users to quickly see job status and history.
In addition, our web application includes a detailed log for troubleshooting any job failures. By providing a single-click solution to identify the cause of any failure, our application significantly reduced the amount of time required to address job failures. Furthermore, our web application allows for easy rerunning of past/failed jobs, simplifying the process of managing job.
Our solution also includes a simple way to configure user rights and user groups, which eliminates the need for users to access SQL Server Management Studio or give high permission levels. Configuring new jobs or replicating existing ones is now a breeze, and the centralized portal allows for easy management of jobs across multiple instances.
Solutions Benefits
- Improvement in addressing job failures by 80%
- On-time data load that increased the productivity
- Reduction in turnaround time to configure the jobs by 50%
- Eliminating the need for users to log into the SQL server.
- Easy configuring/monitoring/ status tracking through an at-a-glance overview of the job environment
- Easy management of jobs over multiple instances
About Us
UB Technology Innovations, Inc. (UBTI) is a leading global technology solution provider with more than 3 decades of experience across all industries, specializing in Capital Markets (Asset Management), Logistics and Healthcare. We are the preferred Microsoft Gold Certified partner backed by a world-class team of Microsoft Certified experts with rich experience in Azure Cloud Platform and Data Analytics.
Winner of the prestigious Azure
Synapse Hackathon 2021 award
One of the Top 10 winners of the
Micorosoft’s Azure AI & ML Workathon