Filter
Top Products
14 VIOM database
Trigger description relating to the full backup job in the quartz_
jobs.xml file
<trigger>
<cron>
<name>cronFullBackupJobTrigger</name>
<group>MSSQL-cron</group>
<description />
<job-name>FullBackupJob</job-name>
<jop-group>MSSQL</jop-group>
<cron-expression>0 0 19 ? * FRI</cron-expression>
</cron>
</trigger>
The trigger description above only belongs to the job called FullBackupJob
of SQL Server. There are also trigger descriptions for the Incre-
mentalBackupJob and BackupLogJob jobs.
To change the execution time for a backup job, you must open the quartz_
jobs.xml file and update the Quartz cron expression in the trigger description
relating to the relevant backup job. For a description of Quartz cron expres-
sions, see section "Syntax of Quartz cron expressions" on page 340.
14.1.1.1 Syntax of Quartz cron expressions
This section provides a brief explanation of the Quartz cron expression syn-
tax. In the context of the VIOM Backup Service, a cron expression describes
when one of the database backup jobs defined for your database will
execute.
A Quartz cron expression is a sequence of six to seven fields separated by a
blank. The following fields are allowed:
Field Mandatory Values Special characters
Seconds yes 0 - 59 , - * /
Minutes yes 0 - 59 , - * /
Hours yes 0 - 23 , - * /
Day of Month yes 1 - 31 , - * / ? L W
340 ServerView Virtual-IO Manager