Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
TopicDescriptionScreenshot
PortletFirst the cron job administration portlet to your page, see Further Administration Portlets.
Cron Job

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


User

Avoid to run cronjobs using a user with the developer role due to the following reasons:

  • Having a developer role does not bring any benefit in recalculating data nodes.
  • Behind the scene, pool users are create for running the cronjobs and they will use up the number of developer roles allowed by the license.


Type of data source
DataNodefor normal projects
ProjectCloneDataNode for template projects, see Working with Template Projects.
Solution for Solution Runner



Status
colourYellow
titleV 6.108

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.

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
ByPeriodImmediateStart
Interval

Repetition rule

-1 means "don't care".

Interval in seconds


KeySolution 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 parallelismOne - 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

PasswordWhen 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


Using stored procedure

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

Code Block
languagesql
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






...