Description of Scheduler

image_pdfimage_print

In the Scheduler component of Jedox, tasks can be started and stopped, edited, and deleted, depending on the user’s rights. New PDF batch jobs can be created in the Reports component, and new Integrator jobs can be organized in the Integrator component. For tasks, a user context in which the task is generated can also be defined.

It is not possible to execute a batch PDF task for reports that use OLAP connections to external OLAP instances where the “Use Login credentials” option is set.

As of Jedox Version 6.0 SR1, you can start up to 16 tasks at the same time. If you want to start more tasks at the same time, you can increase the default value in the file
…\Jedox Suite\tomcat\webapps\rpc\WEB-INF\classes\scheduler-quartz.properties. Look for the following line:

org.quartz.threadPool.threadCount = 16

Increase the value of the entry on the right and then restart Jedox Suite TomcatService

Example Batch PDF

Below are two task examples. We will create the task “Weekly Report as PDF” as a batch PDF and the task “Daily database backup” as a Jedox Integrator job.

Select the folder “Executive Reports” in Demo Reports→Bikers Best→Reporting as shown on the right in User preview mode. Then right-click on the file and select “Batch PDF…”.

The Batch PDF Wizard will guide you through PDF creation.

At the first dialog box, you can select reports for the PDF file by holding down the CTRL key. If you select a folder, all reports of the folder will be printed in the PDF. For this example, select the report “Finance Cockpit”.

In the second dialog box, you can select the variables and/or the values that you want to use for PDF creation:

In “Private Varsets”, you can save a selection just for yourself, and in “Global Varsets”, you can save a selection for all users. For this exercise, we will use Global Varsets. Click the icon on the lower left and enter the varset name “14_16” to save the displayed selection. The existing global varset “Annual Report” selects “All Values”.

In the third dialog box, you can set the sort order and the entries for the header for a PDF consisting of several reports and multiple variables. With the option “Group by Report”, the PDF will show report 1 with all variables first, then report 2 with all variables, and so on. With “Group by Varset”, the PDF will show all reports with variable 1 first, then all reports with variable 2, and so on.

In the fourth dialog, select the option “Task Generation”:

In the next dialog box, you can select the displayed PDF document restrictions. You can also assign a password to open the document. If you assign a password, then the option “No Restrictions Password” is active. If the document is opened using that password, then assigned PDF document restrictions are not effective.

In the next dialog box, most fields are self-explanatory. We will explain the option “Choose store type” below.

Send via email

PDF will be sent via email to all users who execute the task.
Prerequisites: The users must have a valid email address and at least R rights on the following rights objects: database, cube, dimension, and dimension element.

Store to server
Example 1: Location type Filesystem

The selected path and folder must already exist.

Prerequisites:
The users must have at least R rights on the following rights objects: database, cube, dimension, and dimension element.

Store to server:
Example 2: Location type Report Designer

You can browse in the existing folders of the Report Designer component and also create new folders:

Prerequisites:
The users must have at least W rights on rights object “dimension element” and the R rights on the following right objects: database, cube, and dimension.

In the next dialog box you can specify which user(s) should execute the task:

With “Go over Groups”, a PDF can be stored on the server for each user of the selected groups or a PDF can be sent to each user as an email attachment. 

Note: if “Store to server” is selected, then no mails at all will be sent. The information in the dialog above “The resulting file(s) will be sent to their respective email addresses” isn’t correct in this case (Version 6.0 SR3) and will be corrected in a future release.

Finally, click “Execute” to create the task in Scheduler. Depending on your rights, you can edit, stop, delete, or start the task.

Possible results after the execution of the task
Send via email

All users, who have executed the task, will receive an email. The created PDF will be attached. In this case the created PDF(s) will not be stored on the server.

Store to File System

Result example in folder C:\_Jedox:Reports_PDFs
(Checked “Go over Groups” with all groups of a default installation):

Store to Report Designer

Result example (Checked “Go over Groups” with groups “admin” and “designer” of a default installation):

Click “Refresh” to actualize screen with the created PDFs.

Example Jedox Integrator Job

There is another way to create tasks in the Integration Manager. Double-click on any job in Integrator and then click the icon “Schedule” to create a task:

The further procedure is the same as in the example “Batch PDF”.

Trigger type ‘Cron‘

As a variant we select the trigger type “Cron”:

The selection of the trigger type “Cron” (from Chronos, time) provides 6 fields for the definition of a Cron expression. This determines at what second, what minute, etc. a task will be started.

For “Custom” the following entries are possible:

 

Possible values

Possible characters

Second

0-59

, – * /

Minute

0-59

, – * /

Hour

0-23

, – * /

Day (of the month)

1-31

, – * ? / L W

Month

1-12

, – * /

Weekday
(Sunday=1, Saturday=7)

1-7

, – * ? / L #

Legend:

Character

Description

,

delimiter in listings

 –

character for range (from to)

*

wildcard 1 (=Selection ‘All‘: each value is taken)

?

wildcard 2 (exactly one matching value is taken)

/

character indicating the increment

L

last day

W

it must be a working day (Monday – Friday)

#

specifies the n-ith day of the month
Important notes:
  • The day of the month and weekday may not both be set at the same time. One of them needs a “?” for adapting to the entry in the other field. 
  • Avoid time ranges in which clocks are changed (daylight)!
  • A Cron expression is composed of the entries of the 6 fields from “second” to “weekday” (separated by a space). Below are some examples:

Cron expression

Description

0 0 12 * * ?

at 12:00pm (noon) every day

0 15 10 ? * *

at 10:15am every day

0 * 14 * * ?

every minute starting at 2pm and ending at 2:59pm, every day

0 0/5 14 * * ?

every 5 minutes starting at 2pm and ending at 2:55pm, every day

0 0/5 14,18 * * ?

every 5 minutes starting at 2pm and ending at 2:55pm, AND every 5 minutes starting at 6pm and ending at 6:55pm, every day

0 0-5 14 * * ?

every minute starting at 2pm and ending at 2:05pm, every day

0 10,44 14 ? 3 4

at 2:10pm and at 2:44pm every Wednesday in the month of March

0 15 10 ? * 2-6

at 10:15am every Monday, Tuesday, Wednesday, Thursday and Friday

0 15 10 15 * ?

at 10:15am on the 15th day of every month

0 15 10 L * ?

at 10:15am on the last day of every month

0 15 10 LW * ?

at 10:15am on the last working day (Mon-Fry) of every month

0 15 10 15W * ?

monthly at 10:15 on the nearest working day to the 15th of the month

0 15 10 ? * 2#1

at 10:15am on the first Monday of every month

0 15 10 ? * 6#3

at 10:15am on the third Friday of every month

0 15 10 ? * 6L

at 10:15am on the last Friday of every month

0 0 12 1/5 * ?

at 12:00pm every 5th day of the month, beginning on the first day of the month

If you specify “1W” as the value for the  day of the month, and the 1st is a Saturday, the trigger will fire on Monday the 3rd, as it will not cross over the boundary of a month’s days. The “W” character can only be specified when the day of the month is a single day, not a range or list of days.

With the button “Next” in Task Wizard you receive the following dialog:

Here you can specify which persons will be notified upon completion of the task.

The email addresses of users who should be notified can be registered in the user’s properties form in the “Users” section of Jedox Web Administration. Alternatively, it can be set via a Spreadsheet View of the cube #_USER_USER_PROPERTIES in the System database.

Below you can also enter custom e-mail addresses.

The mail server that is used for sending emails is configured in the “Settings” section of Jedox Web Administration. For details, please see the article Adjusting Email Notification Settings.

On the next dialog you can decide which user will run the job:

Press “Finish” to create this task in Scheduler.

Display in Scheduler

The Scheduler displays the tasks that are not yet finished, and the logs of jobs that are already completed:

Depending on your access rights, you can start and stop tasks, edit or delete them.

General tab

Here you can change for example start and stop times or execution times.

image_pdfimage_print
Was this post helpful?
NoYes (0 rating, 4 votes)
Loading...