Schedule a dynamic report

Prev Next

Schedule a dynamic report to run at a specific time.

Note

This report is available only in .xls and .pdf formats.

Procedure for scheduling a dynamic report remains same for Dynamic Alert Reports, Dynamic VA Result Reports, and Dynamic System Reports.

The following procedure explains how to schedule a Dynamic Alert Reports:

  1. On the Reports page, in the Dynamic Alert Reports tab, click the Properties icon GUID-935B8A59-8600-4F15-943C-F3EEA12A79A6-low.png in the required row.

  2. In the Dynamic Reports list, click the properties icon GUID-935B8A59-8600-4F15-943C-F3EEA12A79A6-low.png in the row for the report. The properties of the dynamic report are displayed in the dynamic reports tab.

  3. To schedule the report generation at regular intervals, select the Schedule enabled checkbox and configure one of these scheduling intervals:

    • To run a report at intervals, select by hour every, then select the interval between each report generation.

    • To run the report on the required days, select by day, then select the days of the week and the time to run the report.

    • To run the report on a monthly basis, select by month every, then select the number of months between each report generation and the time to run the scan.

    • To run the report on an advance scheduling, select advanced cron, enter the expression based on the cron syntax.

    • To run the report only once on the scheduled time, select Run Only Once.

  4. Set the email address to receive the report output file. You need to configure the email server on the System tab first.

  5. Click Save.

The report definition is updated to include the new schedule settings.

The scheduled report output is saved in the Database Security server machine to the path specified in the properties file <Server root>\webapps\ROOT\WEB-INF\config\reports\britConfig.properties in the server.reports.xls Directory property, which is by default located in the <Server root>\webapps\ROOT\export\ folder.

Advanced scheduling is based on cron syntax.

Field Name

Mandatory

Allowed Values

Allowed Special Characters

Seconds

Yes

0–59

, - * /

Minutes

Yes

0–59

, - * /

Hours

Yes

0–23

, - * /

Day of month

Yes

1–31

, - * ? / L W

Month

Yes

1–12 or JAN-DEC

, - * /

Day of week

Yes

1–7 or SUN-SAT

, - * ? / L #

Year

No

empty, 1970–2099

, - * /

Examples of advanced scheduling:

Expression

Schedule

0 0 12 * * ?

Run at 12 p.m. (noon) every day

0 15 10 ? * *

Run at 10:15 a.m. every day

0 15 10 * * ?

Run at 10:15 a.m. every day

0 15 10 * * ? *

Run at 10:15 a.m. every day

0 15 10 * * ? 2005

Run at 10:15 a.m. every day in 2005

0 * 14 * * ?

Run every minute starting at 2 p.m. and ending at 2:59 p.m., every day

0 0/5 14 * * ?

Run every 5 minutes starting at 2 p.m. and ending at 2:55 p.m., every day