Scheduled tasks

Scheduled tasks and allows you to run reports unattended at a defined schedule. You can control which reports are run at which time within myDBR application.

Things you can do with scheduled tasks:

Configuration

To run the scheduled tasks, you will create an entry for myDBR for the job scheduler (usually in your server: cron in Unix/Linux and Task Scheduler in Windows) to call myDBR functionality scheduler.php. A sample entry that would run every half an hour could look like this:

0,30 * * * * /opt/local/bin/wget -O - -q -t 1 https://myserver.com/mydbr/scheduler.php > /dev/null 2>&1

The scheduler.php looks for jobs that need to be run inside the myDBR and executes them. You should decide the interval in which the scheduler.php is run based on your need. The actual run itself, if no tasks need to be run, is light on resource usage. The tasks are run sequentially.

To configure the scheduled tasks environment, go to "Environment settings" / "Scheduled tasks" and define a local myDBR user which is used to run the reports and IP's that are allowed to call (cron) the scheduler.php. In the example, we have created a local myDBR use scheduler and allow the scheduler.php to be run from the server only.

To configure the actual scheduled tasks, go to "Admin Tools" / "Scheduled tasks" and add a new task. A task is added as a cron type interface which will determine what report is run at which time (the actual report execution is done at the time interval defined in the job scheduler's run). You can also disable defined tasks if

Troubleshooting scheduled tasks

If you have problems with the scheduled tasks, you can see what is going on by adding ?debug=1 at the end of the scheduled tasks URL and calling the URL. Detailed debug information is printed.

/opt/local/bin/wget -qO- "https://myserver.com/mydbr/scheduler.php?debug=1"