Setting the Fulfilment Details

To set the details of a Fulfilment that you’ve added — including the schedule and SQL Select statement — follow these steps:

1. From the Fulfilment’s Fulfilment details page, click in the Fulfilment details section.
2. Under Active, click Yes to make the Fulfilment active or No to make it dormant.
3. (Optional) In the Fulfilment name box, type a more meaningful name for your Fulfilment.
4. In the Description box, type a description for your Fulfilment.
5. In the When should the fulfilment be performed dropdown, select whether the Fulfilment should be repeated Every X second(s) / Every X minute(s) / Every X hour(s) / Every X day(s) / Every X week(s).

6. In the How often should the fulfilment be repeated box, type a number representing the X in the When should the fulfilment be performed dropdown.

   EXAMPLE 

   For his Fulfilment, Jack enters the following details:

   • When should the fulfilment be performed: Every X hour(s)
   • How often should the fulfilment be repeated: 2

   Jack’s Fulfilment runs every 2 hours.

7. In the Date and Time boxes under Schedule begins, enter the date and time when the Fulfilment should first be run.
8. (Optional) In the Date and Time boxes under Schedule ends, enter the date and time after which the Fulfilment should no longer be run.
9. (Optional) In the Error if number of records larger than box, type the maximum number of records allowed in the result set of your SQL Select statement. If the result set is ever greater than this number, then an error will be thrown and the Fulfilment actions will not be performed.
10. In the Database name dropdown, select the database against which the SQL Select statement should be run.

11. In the Select statement box, type your SQL Select statement.

    Tip: Under synTelate's SQL Functions, you can double-click a function to add it to your SQL Select statement. For more information, see synTelate's SQL Functions.

    To check whether your SQL is valid, click Check SQL. A dialog box appears telling you either that your SQL is valid or else reporting an error.

12. Click .