Jobs

The Jobs tab provides the ability to manage connection jobs.

Available operations:

• Add jobs to the connection by clicking on the Add Job button
• View the jobs associated with the connection
  • Columns available
    • ID – System Id of the job
    • Job Description – Description of the job
    • Active – Whether the job is active (Yes, No)
    • Allow Empty Table (hidden by default) – Whether an empty table is allowed (Yes, No)
    • Destination Table – Name of the destination table (e.g., my_table_cm_computer)
    • Data Identity (hidden by default) – Identity of the data for dashboards (e.g., cm_computer)
      • AD – Identify data to query from a table
    • Static Definition (hidden by default) – Whether the table definition is static (Yes, No)
    • Job Schedule – Frequency the job will run (Weekly, Daily, Hourly, Custom)
    • Data Processing (hidden by default) – Processing of the data
      • Future field to be used for running a process against data
    • Fields to Index (hidden by default) – Fields to index
    • Data Selection (hidden by default) – Connector specific data selection command of the job
    • Request Filter (hidden by default) – Fields to filter from the job (AD only)
    • Request Fields (hidden by default) – Fields requested by the job (ServiceNow only)
    • Request Sort By (hidden by default) – Field to sort the job by (AD only)
    • Request Limit (hidden by default) – Request limit of the job (Druva, ServiceNow and CrashPlan only)
    • Order – Order job should run
    • Connection Label (hidden by default) – Unique label to prepend to all database tables
• Edit jobs by selecting a job (row) and clicking the Edit Job button on the toolbar
• Deleting jobs is currently not supported
• You can also change the number of visible rows in the table, set column visibility, export to CSV or Excel, refresh the table and search for text

New Job

From the Jobs tab, you can create new jobs.  To create:

1. Click the Add Job button to bring up the New Job dialog
2. Enter the properties of the new job
   
   1. Populate Job Record – Choose how to populate the job (optional)
      1. Clear Job Record – Start with an empty record
      2. Use Template – Start with a template job
      3. Clone Job – Start with a clone from an existing job
   2. Job Description – Description of the job (required)
   3. Active – Choose if job is active (required)
   4. Allow Empty Table – Choose if an empty table is allowed (required)
   5. Destination Table – Name of the destination table (e.g., my_table_cm_computer) (required)
   6. Data Identity – Identity of the data for dashboards (e.g., cm_computer) (required)
      • AD – Identify data to query from a table
   7. Static Definition – Choose if the table definition is static (required)
   8. Job Schedule – Choose the frequency the job will run
      1. Weekly
      2. Daily
      3. Hourly
      4. Custom
   9. Data Processing – Processing of the data (optional)
      • Future field to be used for running a process against data
   10. Order – Choose the order the job will run at the designated frequency (required)
   11. Fields to Index – Fields to index (optional)
   12. Data Selection – Connector specific data selection command of the job (optional)
   13. Request Filter – Fields to filter from the job (AD only) (optional)
   14. Request Fields – Fields requested by the job (ServiceNow only) (optional)
   15. Request Sort By – Field to sort the job by (AD only) (optional)
   16. Request Limit – Request limit of the job (Druva, ServiceNow and CrashPlan only) (optional)
3. Click the Add button when finished to create the job. You will be redirected back to the Jobs tab. Click the Close button to cancel the operation.
   1. The new job function is only available to users in the Administrator security group

Edit Job

From the Jobs tab, you can edit jobs.  To edit:

1. Select a job (row) to edit
   
2. Click the Edit Job button on the toolbar to bring up the Edit Job dialog
   
   1. The edit button is grayed out unless a job (row) is selected
      
      
   2. The edit function is only available to users in the Administrator security group
3. Edit the properties of the job
   
   1. Job Description – Description of the job (required)
   2. Active – Choose if job is active (required)
   3. Allow Empty Table – Choose if an empty table is allowed (required)
   4. Destination Table – Name of the destination table (e.g., my_table_cm_computer) (required)
   5. Data Identity – Identity of the data for dashboards (e.g., cm_computer) (required)
      • AD – Identify data to query from a table
   6. Static Definition – Choose if the table definition is static (required)
   7. Job Schedule – Choose the frequency the job will run
      1. Weekly
      2. Daily
      3. Hourly
      4. Custom
   8. Data Processing – Processing of the data (optional)
      • Future field to be used for running a process against data
   9. Order – Choose the order the job will run at the designated frequency (required)
   10. Fields to Index – Fields to index (optional)
   11. Data Selection – Connector specific data selection command of the job (optional)
   12. Request Filter – Fields to filter from the job (AD only) (optional)
   13. Request Fields – Fields requested by the job (ServiceNow only) (optional)
   14. Request Sort By – Field to sort the job by (AD only) (optional)
   15. Request Limit – Request limit of the job (Druva, ServiceNow and CrashPlan only) (optional)
4. Click the Update button when finished to update the job. Click the Close button to cancel the operation.

Delete Job

Deleting jobs is not currently supported.

NOTE: Contact ReadyWorks Support to delete jobs.