Using the SQL Server Agent Conversion Utility

Follow

External Tab

The External Tab can be used to view information about the SQL Server Agent Jobs located on the computer running the JAMS Client, as well as Jobs located on other servers.

Task Scheduler jobs may also be converted from the External Tab, directions for doing so are provided here.

Displaying Jobs

To view the Jobs installed on the current machine, simply select the SQL Agent Ribbon Bar Tab.  Then, click the SQL Agent Jobs shortcut in the Shortcut bar to the left.  By default, this will display all the SQL Agent Jobs currently configured on the local machine.  If no Jobs are displayed, there may not be any SQL Agent Jobs configured on the current machine.

To display the configured Jobs on a remote machine, right click on the shortcut bar, and choose the Add Shortcut option. Enter a new name for the shortcut.

 

Next, select the Query tab.  In the Server Name field, enter the name of the SQL Server instance to connect to.

 

Press OK to add the new Shortcut to the Shortcut Bar. When the newly added shortcut is selected, the Jobs on the remote machine will be displayed. If no Jobs are displayed, ensure that there are SQL Agent Jobs present on the remote instance.

 

Converting Jobs

It is very easy to convert a SQL Server Agent Job to a JAMS Job. Simply select a Job from the Job list, right click, and choose the Convert option. You can also use the Convert to JAMS button in the Ribbon Bar.

Note: SQL Agent Job conversion requires a connection to a JAMS Scheduler. The free version of JAMS does not support converting SQL Agent Jobs to JAMS Jobs. A licensed version of JAMS is required.

 
A Conversion Wizard will now begin, which walks though all the steps required to convert an Agent Job to a JAMS job. On each step of the wizard, fields will be pre-populated with information from the selected SQL Agent Job. You can then change the retrieved information before the new JAMS Job is created.

Since some SQL Agent Jobs will contain multiple Job Steps, these Agent Jobs will be converted to JAMS Setups, with two or more Jobs.

It is also possible to convert multiple SQL Agent Jobs at the same time. Just select several Agent Jobs from the Jobs list and click the Convert to JAMS button. This will start the Wizard for converting multiple Jobs. The first few steps will prompt for information common to all of the Jobs selected for conversion. The Wizard will then attempt to convert all of the selected Jobs to JAMS Jobs.

 

Other Actions

SQL Agent Jobs can also be started, stopped, and deleted from the SQL Agent instance. Simply select a Job from the Job list and click the appropriate button on the Ribbon Bar.

Have more questions? Submit a request

Comments