Topic | Description | Screenshot | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
Portlet | First 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:
From the TIS Version 6.9 further it is not possible to run cronjobs using a user with developer roles/rights | |||||||||
Type of data source |
| |||||||||
for v6.9
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 |
| |||||||||
Repetition rule |
| |||||||||
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 | |||||||||
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 | |||||||||
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.