Unable to edit IW data source job schedule via SQL Server Agent
search cancel

Unable to edit IW data source job schedule via SQL Server Agent

book

Article ID: 237992

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

If an Integration Wizard (IW) data source query job has been scheduled to run on a daily cadence, the job schedule under the SQL Server Agent is configured to run a multiple of 1440 minutes (1 day = 1440 minutes) and cannot be edited except via the data source query's configuration in the Information Centric Analytics (ICA) console. If you attempt to edit the schedule via SQL Server Management Studio (SSMS), the following error is returned:

Value of '1440' is not valid for 'Value'. 'Value' should be between 'Minimum' and 'Maximum'.
Parameter name: Value (System.Windows.Forms)

Similarly, if an IW data source query job has been scheduled to run on an intraday cadence every n minutes (where n is any value greater than 100), the job schedule under the SQL Server Agent is also uneditable in SSMS and returns the same error (referencing the value in question, e.g. '101'). For the intraday cadence, note that this value needs to be entered in ICA as minutes, not hours and minutes (e.g., Hours: 0, Minutes: 101; not Hours: 1, Minutes 41).

Environment

Release : 6.5.4

Component : RiskFabric Processing

Cause

This behavior is under investigation by ICA engineering.

Resolution

No workaround has yet been identified and an ETA for a fix is not yet available.

Note that processing jobs still run successfully despite this behavior. No additional action is required.