Job Information

The Job Information tab of the Query Scheduler page allows you to create, edit, delete, or run a job.

It contains two types of fields:

To clear the form of all Read-Only fields and specified inputs, click the Clear Form button.

Read-Only Fields

Job Owner ID
The user ID that created the job, which is not necessarily the same as Job Runner ID.

Administrators can set this to any user ID within their company.

Job Runner ID
A valid 1010data user ID that will execute the job.
Note: This field is automatically set to your user ID.
Job ID
The unique identifier of the job. (This field is auto-generated.)
Cron String
The frequency of the job.
State
Indicates whether the job is Active (scheduled to run sometime in the future) or Inactive (not scheduled to run).
Current Status
The current status of the job.
This can be one of the following:
  • Scheduled – The job is scheduled to run, but is not in the process of running.
  • In Progress – The job is in the process of running.
  • Failed – The job recently ran and failed.
  • Ended – The job recently ran and succeeded.
Last Run Status
The status of the job when it last ran, indicating whether it succeeded (Ended) or failed (Failed).
Last Run TS
The time the last job ran.
Note: This timestamp is in GMT.
Last Run Msg
The error message associated with the job if it failed in its last run.

User Input 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.
Unsubscribed Report Recipients
A space-separated list of user IDs that have unsubscribed from the report.

This list provides a way for company administrators and job owners to see who unsubscribed from reports (via the Unsubscribe link in the distribution emails) and, if necessary, re-subscribe them by removing them from this list.

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.

Query Text
The Macro Language code to run.

You must specify a base table path in Quick Query/Base Table Path or ID.

Note: Leave this field blank if you specify a Quick Query in the Quick Query/Base Table Path or ID field.
Gateway Version
The version of 1010data on which to run the job.
Possible values are:
  • prod-latest
  • beta-latest
  • prod-x.yz
  • beta-x.yz

where x.yz is the specific version (e.g., prod-7.47, beta-8.04)

If a Gateway Version is not specified, the default is the version of 1010data the user is configured to use; if there is no version configured for the user, the default is the version of 1010data the user's company is configured to use.
Note: This is not necessarily the same version as the one the user was logged into when they created the job.
Output Format
The format of the report.
The options are:
  • ALL - all three formats
  • CSV - comma-separated text file
  • XLS - Excel workbook
  • PDF - PDF document
The default option is CSV.
Frequency
How often you want the job to run.
Hourly
From the drop-down, select the number of hours you want to pass before running the job again.
Daily
Enter the time you want the job to run. From the drop-down list, select how many days you want to pass before running the job again.
Weekly
Enter the time you want the job to run. From the drop-down list, select which days of every week you want the job to run.
Monthly
Enter the time you want the job to run. From the drop-down list, select which days of every month you want the job to run.
Note: Execution will not always occur at the exact time specified, as it depends on the schedule queue and available resources.

The following selections will change based on the selected Frequency option. This combination of selections will generate a standard crontab entry.

Time Zone (GMT Offset)
The time zone in which you’d like the job to run.

It is pre-selected with the Time Zone specified under the Location section of your user preferences, though you can change it to any other option.

Note: Time zone offsets are set values that are not affected by DST.
Job Expiration Date
The date (in YYYYMMDD form) you’d like to deactivate the job.

You can click on the calendar icon () to select the date from a date picker. Click anywhere outside the date picker to dismiss it.

If you set the Job Expiration Date to a past date, the job will never run. To reactivate a job, simply delete the value in this field.

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.

Use the following email addresses for all error notifications
When this check box is selected, all the email addresses in the Recipient Email Address(es) for first error notification field will be copied to the Recipient Email Address(es) for second error notification and Recipient Email Address(es) for third error notification fields.
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).