SQL job manager is Idera’s next generation solution for scheduling and managing SQL Server jobs across your enterprise. SQL job manager gives you a simple way to see jobs that have run or are scheduled to run on one or many SQL Servers, schedule or edit jobs and quickly and easily re-schedule jobs by dragging and dropping them on a calendar.
SQL job manager provides a time-saving solution for managing SQL Agent jobs across the enterprise. SQL job manager streamlines the process of cross-server SQL Server job management, dramatically reducing job failure rates and time spent on tedious job management activities.
Major Features of SQL Job Manager
Management Console : View SQL Server jobs and scheduled jobs across your SQL enterprise from a single console. Manage jobs by simply dragging and dropping from within a single server or from one server to another. Print job schedules directly from the console.
Identify SQL Job Contention : See jobs and identify job contention across multiple servers. Maximize hardware resources and improve application performance by leveling jobs across available resources.
Level Job Workload : View jobs across the SQL Server infrastructure and more easily balance workloads via drag and drop of jobs across servers ensuring optimum use of system resources.
At a Glance View of Jobs : Quickly and easily see job status in the job tree and get comprehensive details about jobs, such as start time, run time and average run time, by hovering over the information icon of a specific job. This information will pinpoint areas where problems may exist, such as long running and runaway jobs.
Calendar View : Five calendar viewing options paired with four job status filter options mean complete flexibility to customize the view to see more granular schedules and quickly find the information most important to you. Frequently running jobs can be omitted from the calendar view to obtain a higher level understanding of job operations.
Connect to Cloud and Run in Cloud (Provisional) : Connect to database instances hosted in the cloud, such as SQL Server on Azure Virtual Machine (VM).
Installation Instructions For Windows
A) Click the Windows “Start” button and select “All Programs” and then point to SQL Job Manager
B) RDP Connection: To connect to the operating system,
1) Connect to virtual machine using following RDP credentials :
- Hostname: PublicDNS / IP of machine
- Port : 3389
Username: To connect to the operating system, use RDP and the username is Administrator.
Password : Please Click here to know how to get password .
C) Other Information:
1.Default installation path: will be on your root folder “C:\Program Files\Idera\SQLjm Installation Kit”
- Windows Machines: RDP Port – 3389
- Http: 80
- Https: 443
Configure custom inbound and outbound rules using this link
Users Instructions Screenshots
1. Click On SQL Job Manager
2. Click on Next
3. Click On Add Server
4. Add the Name of Server Instance to Resgister
5. Click Ok
6. Click on Finish.
7. Idera SQL Job Manager will Open.