Trigger Tab

The Trigger tab defines the duration and frequency to run the import schedule.

The Trigger type list includes the event types, described below, that will initiate the data import. Other fields will appear, as needed, for each entry in this list.

Manual

Schedule will not run automatically.

• Test button: Initiates the data import.

Daily

Schedule will run once each day.

• Trigger Time: The starting time for the data import.

Weekdays

Schedule will run once each weekday (M, Tu, W, Th, and F).

• Trigger Time: The starting time for the data import.

Weekly

Schedule will run once each week.

• Trigger Day and Time: The day and starting time for the data import.

Every N minutes

Schedule will run repeatedly during the specified interval.

• Every How Many Minutes: The time interval between data imports.

• Starting and Ending Time: Defines when the first and last data imports will occur.

File exists

Schedule will check every minute for the specified file; when the file is found, the schedule will run.

• File Path and Name: The path and name of the file triggering the data import. The Browse (...) button opens a file browser window.

Note: The MES middleware user account must have access to the file directories that are used by Supply Chain Connector. For information about how the MES middleware user account is specified, see the MES Installation Guide.

Table data exists

Schedule will connect to the specified database and run the specified query every minute; when data is returned the schedule will run.

• DB Connection String: Full connection string to access the database. For example:

  Provider=SQLOLEDB;Data Source=1.1.1.1\MES;Initial Catalog=MESDB;Integrated Security=SSPI;

• Test button: Tests the DB Connection string, to ensure the database is accessible.

• Query: The database query, which will generate the import data.

• Test button: Tests the query.

Completed SCC schedule

Schedule will run when another import or export schedule has finished running, if that schedule did not fail.

• Import Schedules: The import schedule will run.

• Export Schedules: The export schedule will run.

• Trigger Schedule: The import schedule after which the current import schedule will run.

Completed or failed SCC Schedule

Schedule will run when another import schedule has finished running, regardless of its success or failure.

• Trigger Schedule: The import schedule after which the current import schedule will run.

To modify the trigger, select the desired field and change its value. Click Save to keep your changes or Cancel to discard them.