Share via


Execute SQL Server Agent Job Task (Maintenance Plan)

Use the Execute SQL Server Agent Job Task dialog to execute Microsoft SQL Server Agent jobs within a maintenance plan. This option will not be available if you have no SQL Server Agent jobs on the selected connection.

This task uses the .sp_start_job statement.

  • Connection
    Select the server connection to use when performing this task.

  • New
    Create a new server connection to use when performing this task. The New Connection dialog box is described below.

  • Available SQL Agent jobs
    Select the job to execute. The grid provides the Job name and Description to identify the jobs.

  • View T-SQL
    View the Transact-SQL statements performed against the server for this task, based on the selected options.

    Note

    When the number of objects affected is large, this display can take a considerable amount of time.

New Connection Dialog Box

  • Connection name
    Enter a name for the new connection.

  • Select or enter a server name
    Select a server to connect to when performing this task.

  • Refresh
    Refresh the list of available servers.

  • Enter information to log on to the server
    Specify how to authenticate against the server.

  • Use Windows integrated security
    Connect to an instance of the SQL Server Database Engine with Microsoft Windows Authentication.

  • Use a specific user name and password
    Connect to an instance of the SQL Server Database Engine using SQL Server Authentication. This option is not available.

  • User name
    Provide a SQL Server login to use when authenticating. This option is not available.

  • Password
    Provide a password to use when authenticating. This option is not available.