My Blog

SQL Job Manager on cloud

1-click AWS Deployment 1-click Azure Deployment

Overview

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.

 

7

 

Features

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).

 

AWS

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”
2.Default ports:

  • 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

 

1

 

2. Click on Next

 

2

 

3. Click On Add Server

 

3

 

4. Add the Name of Server Instance to Resgister

 

4

 

5. Click Ok

 

5

 

6. Click on Finish.

 

6

 

7. Idera SQL Job Manager will Open.

 

7

 

Videos


SQL Job Manager on cloud

Related Posts