Automating Microsoft SQL Server tasks

Edit online

You can automate a workload by entering Windows PowerShell cmdlets or commands in the integrated command-line interface.

About this task
An integrated command line is available in the task window from which you can enter PowerShell cmdlets or command-line interface commands. You use the Automate view to work with commands. You can create, save, store, and schedule commands to run at the scheduled time.
Procedure
  1. To open the Automate view, select a workload that you want to work with and click Automate.
  2. Change PowerShell to Command Line.
  3. To run a command, type a command in the details pane and click the Execute icon.
    You can enter the commands with or without specifying fcmcli.
    For example, for each selected workload instance, you can enter a single command or multiple commands, such as: 
    q fcm

    You can also run a saved task by clicking the Open icon, selecting the command file, and clicking the Execute icon.

    The output is displayed in the main window.
  4. Click the Save icon and follow the prompts to save a command for future use.
  5. To schedule a command, click the Schedule this command icon to open the scheduling wizard. Follow the prompts in the wizard to create a schedule for the command.
    The output of the command is displayed in the results pane.
  6. (Optional) Save or send the command output to an email address.
What to do next
You can automate commands from the Protect, Recover, Schedule, and Task List views in Microsoft Management Console (MMC):
  1. Start MMC and select a workload in the navigation tree.
  2. Click the tab for the task you want to do (Protect or Recover).
  3. Automate the command by using one of the following methods:
    Result pane
    Select the item for your task in the result pane, and select Run Scheduled in the toolbar menu. In the Actions pane, click the appropriate task. When the schedule wizard starts, enter the information for each prompt to create a scheduled task.
    Task List pane
    When a task is submitted, it displays in the task list pane. Select the appropriate task, then click Schedule command script in the task list toolbar. When the schedule wizard starts, enter the information for each prompt to create a scheduled task.

    You can also right-click a task in the Task List pane and click Copy. Then, click the Automate tab and paste the command in the field.