Step 7: Setting the Daily Job Run Password

The EnterpriseTrack application requires an automated scheduled task, DailyJob.bat or dailyjob.pl, to run daily. This job updates the project status based on the associated project dates and their relation to the current date, and sends appropriate notification emails. The daily job is password-protected. Use the Configuration Workbench in EnterpriseTrack to set the daily job password. For further assistance, contact Oracle Support.

On Windows

A template script to run the daily job is available at IETRACK_ROOT\utils\DailyJob.bat.

1. Create a file dailyjobpwd.txt in the same directory that the cron job will run from (for example, IETRACT_ROOT\utils\). This file should be owned by the OS user who will run the cron job.
2. Ensure that only the user running the cron job has permission to read this file.
3. Put the daily job password in this file. Set this to the Daily Job Password that you configured using the Configuration Workbench.
4. Edit this file to pass correct values for these parameters to the DailyJob.exe:
   • IETRACK_ROOT: Set this to the full path name to the script file.
   • daily_job_error_email: Set this to an email address at which you would like to receive email reporting errors that occur when the Daily Job is run.
   • hostname[:port]: Set this to the host name and port number at which the SiteWand server listens, for example, Server1.oracle.com. Contact your application server administrator if you need further assistance.
   • accountname: Set this to the SiteWand account name in which Etrack application is installed, for example, etrack.
5. Give the full path to this file on the invocation command in the crontab.

Configure the Windows Task Scheduler to schedule the DailyJob.bat file for execution once every 24 hours (preferably at night). Access the Windows Task Scheduler from the Windows Control Panel.

Note: An email summarizing the daily job is not sent if the server fails while executing the daily job on Windows.

On Linux

Setup a cron job to run DailyJob.pl once every 24 hours (preferably at night). The following example cron entry runs the script every day at 3:00 AM.

00 3 * * * /usr/bin/perl /full-path/DailyJob.pl daily_job_error_email https://hostname[:port] accountname >> etrack.log 2>&1  

1. Create a file dailyjobpwd.txt in the same directory that the cron job will run from. This file should be owned by the OS user who will run the cron job.
2. Ensure that only the user running the cron job has permission to read this file.
3. Put the daily job password in this file. Set this to the Daily Job Password that you configured using the Configuration Workbench.
4. Edit this file to pass correct values for these parameters to the DailyJob.pl:
   • IETRACK_ROOT: Set this to the full path name to the script file.
   • daily_job_error_email: Set this to an email address at which you would like to receive email reporting errors that occur when the Daily Job is run.
   • hostname[:port]: Set this to the host name and port number at which the SiteWand server listens. Contact your application server administrator if you need further assistance.
   • accountname: Set this to etrack. In general this would be the name of the SiteWand account in which Etrack is installed.
5. Give the full path to this file on the invocation command in the crontab.