In TIS Board:

Topic

Description

Screenshot

Portlet

First add the cron job administration portlet to your page, see Further Administration Portlets.

Select the portlet, and click on “Add it!” button.

Cron Job

Add a new line by using the plus-icon in the header

In TIS Editor:

Topic	Description	Screenshot
Cron job	Add new cron job by clicking the “Add cron job” button.

Cron Job Properties:

Topic

Description

Screenshot

User

It is not possible to run cronjobs using a user with developer roles/rights

Data source type (Calculation method)

^DataNode	for template projects
^Solution	for Solution Runner

Cron Jobs require projects to be in template mode. If the template flag is not set on a project used by a cron job, the cron job will report an error.

TIS Board:

TIS Editor:

Repetition Type

^ByDateTime	Year, Month, Day, Hour, Minute, Second
^ByWeekDay	Day as Day of Week 0 = Sunday 1 = Monday 2 = Tuesday 3 = Wednesday 4 = Thursday 5 = Friday 6 = Saturday To be filled in column Day
^ByPeriod	Interval (waits period time before)
^{ByPeriodImmediateStart}	Interval (starts immediately)

TIS Board:

TIS Editor:

Repetition rule

-1 means "don't care".

Interval in seconds

Key

Solution runner script name

Allowed hosts(APPIDs)

Instance ID(s) of TIServices are allowed to run CronJob. If left empty, it means any or all depending on the degree of parallelism

Degree of parallelism

One - CronJob will be executed on one of the instances specified in Allowed hosts
All - CronJob will be executed on all of the instances specified in Allowed hosts

Password

When running CronJob with OpenID authentication the password field must be filled in to be able to run it.

Example

Example for Data source = DataNode: Test Cron Job 2018-03-21 16-08-40.gzip

Portlet settings

TIS Board:

TIS Editor:

Using stored procedure

Use xisp0066 for creating a cron job record in table t1750.

DECLARE @RC int
DECLARE @prid int
DECLARE @retval_out int
 
EXECUTE @RC = [dbo].[xisp0066] 
   @prid OUTPUT
  ,'<id>','default','SUPERUSER'
  ,1                -- source type: data node
  ,'<project>','<datanode>','<key>'
  ,2
  ,-1,-1            -- day month
  ,23,00,-1         -- hh mm ss
  ,-1               -- interval (msec)
  ,0
  ,true
  ,0
  ,@retval_out OUTPUT
 
GO

TIS with SP-EXPERT (SPX)

In case of using TIS with SP-EXPERT the configured user must have the same passwords in TIS and SPX. Generally the authentication is done with SPX. For the cron job execution, the TIS password is used to authenticate with SPX. To do so, reset the password in the User-Management, see TIS Admin, and then set it to the identical password in SPX.

Starting from SPX 19.3 the password must be entered in the cron jobs portlet.

Multiple Instances of TIService are not supported, see also Load Balancing.