Changing the automated job creation schedule
i2 Analyze creates jobs from all automated deletion rules according to the same schedule. By default, it creates deletion-by-rule jobs every hour, on the hour. You can update that schedule by running a stored procedure.
Depending on the database management system that hosts the Information Store database, the IBM Db2 administrative task scheduler or Microsoft SQL Server Agent runs the task that creates deletion-by-rule jobs at intervals that you can configure.
The setting that controls how often the deletion-by-rule jobs are created is stored in the Information Store. Whenever the setting matches the current time, date, and day, the scheduler creates jobs from the deletion rules that have the value of automated set to Y.
- For Db2, a value of
'0 * * * *'
is used.For more information about the format, see UNIX cron format.
- For SQL Server, the following arguments and
values are used:
@freq_type=4,@freq_interval=1,@freq_subday_type=8,@freq_subday_interval=1
For more information about the arguments and values, see sp_add_jobschedule.Note: You must not specify values for the@job_id
,@job_name
,@name
,@enabled
arguments. i2 Analyze provides the values for these arguments.
To change the schedule for automated deletion,
run the
IS_Public.Update_Deletion_Schedule
stored procedure. For example, to run the
deletion-by-rule job creation task only at
midnight, run the stored procedure in the
following ways:
CALL IS_Public.Update_Deletion_Schedule('0 0 * * *');
sp_add_jobschedule
stored
procedure. For example, run the stored procedure
with the following
value:EXECUTE "IS_Public".Update_Deletion_Schedule
@freq_type=4,@freq_interval=1,
@freq_subday_type=8,@freq_subday_interval=24;