IBM Tivoli Storage Manager, Version 7.1

Automating tasks for SQL Server

You can use the Automate view to work with commands. You can save a command and run the command at a scheduled time.

About this task

You can use the Automate view to create, save, store, and schedule commands. Open the Automate view by selecting a workload that you want to work with and clicking Automate. An integrated command line is available in the task window. You can use the interface to enter PowerShell cmdlets or command-line interface commands. The output is displayed in the main window.

Procedure

  1. Change PowerShell to Command Line.
  2. Type a command in the details pane and click the Execute icon to run the command. You can also run a saved task by clicking the Open icon, selecting the command file, and clicking the Execute icon.
    The commands can be entered with or without specifying tdpsqlc. For example, for each selected workload instance, you can enter a single command or multiple commands, such as:
    q fcm
  3. Click the Save icon and follow the prompts to save a command for future use.
  4. 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.
  5. The output of the command is displayed in the results pane. The output can be saved or sent to an email address.

What to do next

There are more ways that you can automate commands from the Management Console. To automate commands from the Management Console, use the Protect, Recover, Schedule, and Task List views.
  1. Start the Management Console and select a workload in the tree view.
  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 databases for your task in the result pane, then select Run Scheduled in the toolbar drop-down menu. Click the appropriate task in the Action pane. 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 there.



Feedback