Create a job

You can schedule a query to run at a specified frequency and have the results sent as a comma-separated text file, Excel workbook, or PDF to one or more users.

To create a job:

  1. Under the drop-down menu corresponding to your username in the top right corner of your 1010data session, click Admin.

    The Account Administration page will be opened in a new tab.

  2. On the Account Administration toolbar, click the Query Scheduler icon ().
  3. Click the Job Information tab.
  4. Enter the information pertaining to the job that you want to schedule.
    At a minimum, you must enter the information in the required fields:
    Job Title
    A non-unique string that can consist of up to a maximum of 50 characters, including spaces. (required)
    Report Recipients (1010data IDs)
    A space-separated list of valid usernames that will receive the reports. (required)

    This field is pre-populated with your user ID.

    Note: There is no limit to the number of recipients of a scheduled report.
    Quick Query/Base Table Path or ID
    The ID or path of the Quick Query to schedule, or the path to the table on which the query specified in Query Text will run. (required)

    You can either specify the ID of a table (e.g., 473854) or its path (e.g., demos.test.table). The system will validate if the path exists and confirm you have access to it.

    First error notification sent after n minutes
    The amount of time allowed to pass between when the job is scheduled to run and when it is supposed to finish. (required)

    If a job doesn’t finish within this amount of time, an alert email will be sent out to the list of recipients specified in the Recipient Email Address(es) for first error notification field.

    Recipient Email Address(es) for first error notification
    A space-separated list of valid email addresses to send an error notification if the job doesn’t finish within the previously specified timeframe. (required)

    It is pre-populated with the email address associated with your 1010data account, though you can set it to any email address(es).

    Second error notification sent after n minutes
    The amount of time allowed to pass between when the job is scheduled to run and when it is supposed to finish. (required)

    If a job doesn’t finish within this amount of time, an alert email will be sent out to the list of recipients specified in the Recipient Email Address(es) for second error notification field.

    Recipient Email Address(es) for second error notification
    A space-separated list of valid email addresses to send an error notification if the job doesn’t finish within the previously specified timeframe. (required)

    It is pre-populated with the email address associated with your 1010data account, though you can set it to any email address(es).

    Third error notification sent after n minutes
    The amount of time allowed to pass between when the job is scheduled to run and when it is supposed to finish. (required)

    If a job doesn’t finish within this amount of time, an alert email will be sent out to the list of recipients specified in the Recipient Email Address(es) for third error notification field.

    Recipient Email Address(es) for third error notification
    A space-separated list of valid email addresses to send an error notification if the job doesn’t finish within the previously specified timeframe. (required)

    It is pre-populated with the email address associated with your 1010data account, though you can set it to any email address(es).

    See Job Information for details on the other fields.

  5. Click Create New Job.

    If there are any issues with the input values, you will see an error message with the syntax: "Transaction failed: specific failure". Otherwise, you will see the message: "Job Created".

    The Job Information tab is repopulated with some new read-only fields related to the new job.

    The job is added to the My Jobs tab.

After the job runs as scheduled, an email containing links to the reports specified in the job (Output Format) will be sent to the users listed in Report Recipients (1010data IDs). See Download a completed job report for details on how to download these reports.