Entering timed commands

Administrator Guide : Administering solidDB® : Entering timed commands

solidDB^® has a built-in timer which allows you to automate your administrative tasks. You can use timed commands to execute operating system commands, to create backups, checkpoints, and database status reports, to open and close databases, and to disconnect users and shut down servers.

Procedure

To enter a timed command, edit the Srv.At parameter in the solid.ini file. The syntax is:

[Srv]

At = At_string

At_string ::= timed_command [, timed_command]

timed_command ::= [ day ] HH:MM command argument

day ::= sun | mon | tue | wed | thu | fri | sat

If day is not specified, the command is executed daily. The format used for time is HH:MM (24-hour format). The following table contains a list of valid commands and their arguments.

The arguments and defaults for different timed commands are:

Command	Argument	Default
backup	backup directory	the default backup directory that is set in the configuration file
throwout	user name, all	no default, argument compulsory
makecp	no arguments	no default
shutdown	no arguments	no default
report	report file name	no default, argument compulsory
system	operating system command For example, in Linux environments: cp solmsg.out solmsg2.out	no default
open	no argument	no default
close	no argument	no default

Example

The following setting starts the following operations daily:

▪Make checkpoint at 8:30 pm.

▪Create a backup at 9:00 pm.

▪Shutdown solidDB^® at 11 pm.

[Srv]
At = 20:30 makecp, 21:00 backup, 23:00 shutdown

Related information

ADMIN COMMAND syntax