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


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



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

Repetition rule

-1 means "don't care".

Interval in seconds


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.

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.

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

(warning) Multiple Instances of TIService are well not supported, see also Load Balancing.

  • No labels