Using client-based schedulers with dbbackex
dbbackex lets you employ your choice of client-based schedulers to automatically initiate NetBackup for SQL Server operations.
The following schedulers are available:
The Windows Task Scheduler. Instructions for using this scheduler are provided in the Microsoft Windows online documentation.
The SQL Server Scheduler. This scheduler is closely integrated with SQL Server. It can be accessed through the Microsoft SQL Server Enterprise Manager.
One distinct advantage of the SQL Server Scheduler is that you can create scripts for database maintenance operations. These operations are initiated as a result of database events that you define. For example, you can create a script that initiates dbbackex and tells it to back up a particular transaction log. You can also create an alert which invokes that script when the transaction log for this database becomes full.
Note:
If you use dbbackex through a client-based scheduler, specify the -np option to ensure that a message box is not generated. However, before you use the scheduler with dbbackex consider the following. Try the dbbackex syntax on the console without the -np option. This command tests for the successful completion of the batch file that you have created for your operation.