Setting up SQL Enhanced Query exports

Use the steps to set up an SQL Query Export.

To display the hidden fields, see the steps in Displaying the hidden SQL Enhanced Query Export parameters.

To set up secured exports, see Setting up secured SQL Enhanced Query exports.

  1. Specify this information to create a scheduled task in the Job Scheduler:
    Task Type
    Export Query Enhanced Task
  2. Configure these parameters for the Export Query Enhanced Task Parameters:
    Folder
    Specify the path for the file to be exported, using the absolute path with respect to the Job Scheduler or file server.
    File Name
    Provide a file name.
    Note: If required, include a date and time reference as part of the file name. For example, Filename_yyyyMMdd_HHmmss.
    Export Type
    Select an export type from the drop-down field. Options include CSV, XLS, and HTML.
    Write Headers
    Select this option to include headers in output file.
    Note: This option works with all formats.
    Selection Query
    Provide your own custom select query. The results of the selection query are used as a filter in the export query.
    Note: This field is not required. However, we recommend you provide a selection query for the export.

    See Selection and Export query examples.

    Batch Size
    Specify a batch size. The default is 20. The maximum allowed is 200.
    Export Query
    Provide your own custom export query. This is the primary query. This field is required.

    See Selection and Export query examples.

  3. Click Submit.