Create an executeQuery job

Qualifiers

  1. You want to create an executeQuery job

  2. A suitable query exists or has been created.

Process

  1. Navigate to the Scheduler / Job tab

  2. Click on New button

  3. Job Type

    1. Module - 'gb

    2. Çlass - 'queries

    3. Method - 'executeQuery'

  4. Parameters

    1. Query ID - enter or lookup the query you will use

  5. Run Times

    1. If the fields below are greyed out, this means the job is a child of another job. The parent job controls the run times. The run times must be updated in the parent job.

    2. Minutes: - click on the minute, minutes or range of minutes you want the job to run on

      1. E.g. choosing 0, 15, 30, 45 would run the job every 15 minutes for the selected run hours.

      2. 'All' is not a recommended setting.

    3. Hours: - click on the hour, hours or range of hours you want the job to run on.

      1. E.g. choosing 6am-9pm would run the job every 15 minutes from 6:00am to 9:45pm

    4. Days: - click on the days you want the job to run on.

      1. Choose 'All' to run the job on any day.

    5. Months: - click on the months you want the job to run on.

      1. Choose 'All' to run the job in any month.

    6. Weekdays: - click on the specify days you want the job to run on.

      1. Monday - Friday is a popular choice for business process jobs and emails.

  6. Delivery Method - choose from either Send Mail or Report Queue

    1. Catch-e recommends using the report queue for regular reports to internal staff for better security

  7. Send Mail (if checked)

    1. Subject - enter the email subject

    2. Body - enter the email body

    3. To add recipients

    4. Recipients: Type - choose from 'to', 'cc' or 'bcc'

    5. Recipients: Name - enter the name

    6. Recipients: Address - enter the email address

    7. Repeat for each recipient you want to add

  8. Report Queue (if checked)

    1. Recipients: User - enter or lookup a user record

    2. Recipients: Name - will populate from selected user record

    3. Recipients: Address - will populate from selected user record

    4. Recipients: Notify - un-check if email advice is not required.

    5. Repeat for each recipient you want to add

  9. Click on Create button