You can create cron
jobs to run your Refresh and Incremental updates.
You can use the Linux crontab command to create cron jobs for your Refresh and Incremental updates. A cron
job will run the DP CLI (with one of the update flags) at a specific date and time.
crontab
file will have one or more cron
jobs. Each job should take up a single line. The job command syntax is:
schedule path/to/command
minute hour dayOfMonth month dayOfWeekwhere:
minute
is 0-59.hour
is 0-23 (0 = midnight).dayOfMonth
is 1-31 or * for every day of the month.month
is 1-12 or * for every month.dayOfWeek
is 0-6 (0 - Sunday) or * for every day of the week.path/to/command is the path (including the command name) of the DP CLI update to run, including the appropriate flag and argument.
0 0 2 * * /localdisk/Oracle/Middleware/BDD/dataprocessing/edp_cli/data_processing_CLI --refresh 10133:WarrantyClaimsThe job would run every day at 2am.
To set up a cron job for updates:
You can also use the Hive Table Detector cron
job as a template, as it uses the Linux flock command and generates a log file. For details, see DP CLI cron job.