Related Documentation › MSSQL Server Jobs › Define a MSSQL Server Job › Search for a Job Step in a Microsoft SQL Server Agent Job

Search for a Job Step in a Microsoft SQL Server Agent Job

You can use the Search MSSQL Job Steps dialog to search for and select a job step that is defined in the Microsoft SQL Server Agent job. You can start a job from the job step that you want.

Follow these steps:

1. Ensure you are connected to the server.
2. Open the Basic page of the MSSQL Server job definition.
3. Complete the following required fields:

   Agent name

   Specifies the name of the agent that runs the MSSQL Server job.

   Job name/job ID

   Specifies the job name or internal job identification (ID) number. Select the Job name or Job ID option button in the MSSQL server job section and then specify the job name or job ID in this field.

4. Click the arrow search button next to the Step name field.

   The Search MSSQL Job Steps dialog opens.

5. (Optional) Specify the search criteria in one of the following fields:

   Job Step Name

   Specifies the name of the job step to filter on.

   Job Step ID

   Specifies the ID of the job step to filter on.

   The default is to include all job steps for the specified field.

6. Click the arrow search button next to the MSSQL Job Step Filter Info section.

   The List of Job Steps table is populated with the job steps that meet the search criteria for the specified job.

   Notes:

   • You can sort the data in the table by clicking on a table column heading.
   • The agent administrator can configure the properties files on the agent to change the fields that are displayed in the table. For more information about configuring the properties files and the available fields that can be displayed, see the CA Workload Automation Agent for Microsoft SQL Server Implementation Guide.
7. Select the job step that you want to start the job from in the table.

   The default is to start the job from the first step.

8. Click Select Job Step Name to specify the step name in the job definition.

   The specified step name of the selected job step is set on the Basic page of the job definition.

Example: Display Details of All Job Steps

Suppose that you want to display details of all job steps for a job named Test job monitoring.

To display details of all job steps

1. Open the Basic page of the MSSQL Server job definition.
2. Enter AGENT_MSSQL in the Agent name field.
3. Select the Job name option button and enter Test job monitoring in the Job name/job ID field.
4. Click the arrow search button next to the Step name field.

   The Search MSSQL Job Steps dialog opens.

5. Click the arrow search button next to the MSSQL Job Step Filter Info section.

   The List of Job Steps table is populated with the details of all the job steps that are defined in the job.

Example: Display Details of a Job Step

Suppose that you want to display details of a job step named Step 2 for a job named Test job monitoring.

To display details of a job step

1. Open the Basic page of the MSSQL Server job definition.
2. Enter AGENT_MSSQL in the Agent name field.
3. Select the Job name option button and enter Test job monitoring in the Job name/job ID field.
4. Click the arrow search button next to the Step name field.

   The Search MSSQL Job Steps dialog opens.

5. Enter Step 2 in the Job Step Name field.
6. Click the arrow search button next to the MSSQL Job Step Filter Info section.

   The List of Job Steps table is populated with the details of only Step 2.