Scheduling an automated task in windows 2008 – HP 3PAR Application Software Suite for Microsoft SQL Licenses User Manual

Page 67

Advertising
background image

For example:

“C:\Program Files\3par\RM\SQL\RMSql.exe” create –i inst01–d test -s

SQLserver

15. On the Schedule tab, further refine the scheduled task by selecting the frequency and start

time of the task.

16. Click Apply and OK when finished.

Result: Virtual copies are created as you have scheduled. Depending on the policy set with
the Recovery Manager for SQL GUI or CLI command, older virtual copies on the system might
automatically be removed if the number of virtual copies exceeds your specified maximum
threshold (see

“Setting the Recovery Manager Policy” (page 29)

).

Scheduling an Automated Task in Windows 2008

To set up Windows Task Scheduler to automatically create virtual copies:
1.

Click Start > Programs > Accessories > System Tools > Task Scheduler.

2.

Click Create Task.

3.

In the Name text box on the General tab, enter a name for the task.

4.

Select the desired options in the Security options area.

5.

Select the Triggers tab.

6.

Click New.

7.

Enter scheduling information for the automatic creation of virtual records.

8.

Select the Actions tab.

9.

Click New.

10. In the New Action dialog box, click Browse.
11. Navigate to the Recovery Manager install location. The default location is:

C:\Program Files\3PAR\RM\SQL

12. In the Add arguments text box, enter:

RMSql.exe create –s <SQL Server> –i <SQL Instance> -d <SQL database>

If the name has spaces, use double-quotes (““) to surround the name.

For more information, see the RMSql CREATE command.

For example:

“C:\Program Files\3par\RM\SQL\RMSql.exe” create –i inst01–d test -s

SQLserver

13. In the Conditions and Settings tabs, refine the scheduled task as desired.
14. Click OK.

Result: Virtual copies are created as you have scheduled. Depending on the policy set with
the Recovery Manager for SQL GUI or CLI command, older virtual copies on the system might
automatically be removed if the number of virtual copies exceeds your specified maximum
threshold (see

“Setting the Recovery Manager Policy” (page 29)

).

Scheduling an Automated Task in Windows 2008

67

Advertising