Scheduling periodic updates

To ensure that the external relational database contains current information from the managers, automate the data conversion process by scheduling the Database Conversion tool to run periodically.

Use the following process to schedule the Database Conversion tool to run periodically:

On UNIX

For example, to run the Database Conversion tool at 2:00 a.m. each day using the property file in Example 5, create the myscript crontab file by typing the following:

#Run at 2 AM every morning
		02***/esm/myscript
		02***/esm/bin/dbconvert -propfile /esm/property1.txt 2>&1 > 
		/esm/dbconvert.log

Cron runs the crontab file automatically at the specified time.

On Windows

To run the Database Conversion tool at 12:00 a.m. each day using the property file, create a batch file and run it with the Windows AT command.

The batch file only updates the database for the gs0300 manager. To create the batch file, type the following:

SET PATH=%PATH%;"c:\Program Files\Symantec\Enterprise Security Manager\Symantec ESM Enterprise Utilities";"C:\Program Files\JavaSoft\JRE\ 1.3.0_02\bin"

cd "\Program Files\Symantec\Enterprise Security Manager\Symantec ESM Enterprise Utilities"

dbconvert -propfile=property2.txt -Desm.managers=gs0300

Save the batch file as dbconvt1.bat in the ESM Utilities directory.

To run the batch file, type the following AT command :

at 00:00 /every: M, T, W, Th, F, S, Su, "c:\Program Files\Symantec\Enterprise Security Manager\Symantec ESM Enterprise Utilities\dbconvt1"