SQL job manager - FREE for a limited time!

printer-friendly versionScreenshot Tour download a trialdownload install


General Issues

bullet What is SQL job manager?

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.
bullet Why is SQL job manager free for a limited time?

It’s the holiday season and we simply want to say thanks for supporting us! Enjoy our gift to you and don’t hesitate to let us know what you think by emailing us at idera@sqltools.com.au
bullet Are there any limitations to the free version of SQL job manager?

You can register up to 20 instances of SQL Server.
bullet Will I be charged for SQL job manager in the future?

Your free copy of SQL job manager is yours to keep forever. There will be no maintenance or renewal fees associated with your free copy of SQL job manager. You will also be eligible for upgrades to future versions of SQL job manager. If you choose to upgrade to future versions of SQL job manager the first year of maintenance from the time you upgrade is free. An annual renewal fee of US$59 (AU$ price will depend on future exchange rates) per managed SQL Server instance will apply after the first year.
bullet How is SQL job manager supported?

If you need support or would like to make a suggestion to improve SQL job manager, please send us an email at idera@sqltools.com.au or call us +61 (0)2 9878 8090


Product Feature Questions

bullet How do I install SQL job manager?

Installation of SQL job manager is very easy and takes only a few minutes. Simply download the product and start the installation from the welcome screen. Follow the prompts in the installation wizard to complete the installation. If you need help getting started using the product, refer to the product Quick Start Guide.
bullet How do I register a server?

Click on the red orb in the top left corner of SQL job manager. Click on ‘Register Server’ and follow the prompts in the registration wizard. You can also right click on ‘SQL job manager’ in the tree to launch the server registration wizard. Once your server is registered, it will appear in the tree. Expand the server in the tree to show all SQL Server jobs on that server.
bullet Why don’t all my server jobs appear in the calendar?

To view activity on one or more servers in the calendar, you must check the server name in the tree.
bullet Why don’t I see my agents’ jobs in the calendar when I first launch the console?

When the SQL job manager console is first launched, it retrieves jobs in the background. The calendar will show your jobs once they’ve finished loading. The console UI is still available for you to use for other tasks, such as registering servers and reviewing jobs in the tree.
bullet Why do some jobs appear transparent in the calendar?

SQL job manger highlights jobs of interest. We assume that if a job runs successfully, it’s of little interest or if a job is scheduled to run and is not in contention with another job, then it is of little interest. To help you quickly identify potential problems, jobs that have failed do not go transparent on the calendar. Additionally, jobs that are scheduled to run in the future but are in contention with another job do not go transparent on the calendar. You can further highlight jobs of interest by using the Filter buttons in the menu bar.
bullet What do the colored icons next to the server names mean in the tree?

A green check means the agent is running and everything okay. A red X means one or more jobs have failed on the server. If there is a red X and the server name appears in red, the agent on the server is stopped.
bullet What do the colored icons mean next to the jobs in the tree?

A green check icon means a job has completed successfully. A warning icon means a job has been disabled and a red x icon means a job failed to complete successfully.
bullet What does the blue icon mean in scheduled jobs appearing in the calendar?

You can hover over the blue information icon for job details including start time, end time, run time, average run time and more.
bullet I have some jobs that reoccur every minute, why aren’t they showing up on my calendar?

By default, SQL job manager automatically hides all jobs that reoccur faster than every 5 minutes. This number is configurable and can be changed by clicking the red orb in the top left corner of SQL job manager, clicking Configure and changing the minutes value next to ‘Autohide jobs that occur faster that every XX minutes’. Keep in mind that your calendar may become cluttered with jobs that are of little interest to you if you decrease the value too low. You may also have to change the calendar view from the default 15 Minute Time Slot to a 5 Minute or a 1 Minute Time Slot.
bullet How do I create/schedule a job?

There are two ways to create/schedule jobs in SQL job manager. Right click on the server name and click ‘Add Job’. A Job Properties – New Job box appears. Complete the information to schedule a job.
bullet How do I manage/edit a job?

There are several ways to manage or edit jobs in SQL job manager. Expand the server name in the tree to show a SQL Server jobs on the server. Right click on the job you want to manage or edit and select from the list. Select Job Properties from the list to edit a job. You can also double click on existing job in the calendar to edit a job.
bullet How do I reschedule a job?

Simply drag and drop the job from its scheduled time to the time you’d like the job to run.
bullet How do I move a job from one server to another?

Select the two servers in the server tree so they appear in the calendar. You can then drag and drop a job from one server to the other. You can also move a job from one server to another in the tree. Click on the job you want to move while holding down the shift key. Then drag and drop the job into the any server you choose.
bullet What is the line that moves down the time column of the calendar?

It is the current time.
bullet How do I print a schedule?

Click on the red orb in the top left corner of SQL job manager. Click on ‘Print…’ and follow the print instructions.

Product Feature Questions

bullet What are the system requirements and prerequisites for SQL job manager?

Windows Installer 3.1

Microsoft .NET 2.0 and a supported operating system:
bullet Windows 2000 SP4+
bullet Windows XP SP2+ (32- and 64-bit)
bullet Windows Server 2003 SP2+ (32- and 64-bit)
bullet Windows Vista
bullet What versions of Microsoft SQL Server does it support?
bullet SQL Server 2000 SP4+
bullet SQL Server 2005 SP1+ Standard and Enterprise Editions, including 64-bit SQL Server on the operating systems they support.
bullet What security permissions are required?

A windows domain account with local administrator privileges is required to install and run SQL job manger. You must also have login access to the SQL Servers you want to manage.
bullet Does SQL job manager currently offer international language support?

No. SQL job manager currently supports English language only.


Copyright | SQL Tools | Legal | Privacy