Skip to main content

Jobs Page

In the Jobs page, you can track the status of all of your jobs and plan runs.

Jobs can be initiated from:

JobsPage.png

Figure: Jobs page

Job Types:

Each job listed in the Jobs page is a grouping of related jobs acting on the same recipe and dataset(s). Each of these jobgroups breaks down into one or more of the following job types.

Tip

To review the status of individual jobs within a jobgroup, hover over the icons in the Status column for the jobgroup.

  • Pre-ingest SQL: These jobs are SQL scripts that execute before the source data is ingested to the platform.

  • Transform: These jobs perform transformations on imported datasets based on the recipe from which the job was launched.

  • Profile: If enabled as part of the job definition, a Profile job generates a visual summary of the results of your transformation job.

    • Profiling jobs may take longer than transformation jobs.

    • Even when selected, profiling jobs may not appear in the Jobs page. In some cases, a profiling job may be folded into a transform job for optimization reasons.

      Note

      When the profiling job is run as part of the transform job, there is no listing for profiling in the mouse-over popup.

    • See Job Details Page.

  • Publish: Depending on multiple factors, your job may include a second Publish job that occurs after the Transform job. For example, jobgroups can include internal Publish jobs for writing results to the designated location in the base storage layer.

    Publishing can also be executed as a separate, post-execution job. As needed, job results can be published from their target location to another location or data store. These jobs are tracked separately as Publish jobs and can be launched from the Job Details page. For more information, see Job Details Page.

  • Ingest: For larger datasets from some relational connections, the platform transfers the data from the source to the default storage layer for faster processing. These ingest jobs occur before any transform or profiling takes place.

  • Post-ingest SQL: These jobs are SQL scripts that execute after the job results have been published.

Tabs and Statuses:

Each of the available tabs corresponds to a possible status for jobs that have been initiated on the platform.

  • All jobs: All jobs that you have initiated are listed here.

  • Completed: Job has successfully executed.

    Note

    Invalid steps in a recipe are skipped, and it's still possible for the job to be executed successfully.

Note

A warning icon may indicate that recipe errors were detected during the Transform phase. You can hover over the icon for more information.

  • Failed: job failed to complete.

    Note

    You can re-run a failed job from the Transformer page. If you have since modified the recipe, those changes are applied during the second run. See Transformer Page.

    • Publish Failed: Some failed jobs may be listed under this status, which means that the publishing step of the configured job failed to complete.

  • Canceled: Job was canceled by the user.

  • Running: Job is in progress.

  • Queued: Job has been queued for execution.

Access:

  • You can review and drill into any job that you initiated.

  • You can also drill into any job that was initiated from a flow that has been shared with you.

  • Administrators can review read-only listings for jobs created by other users.

Columns:

  • Job: Internal identifier for the job. This value is unique for all jobs in your Alteryx instance.

  • User: The Alteryx user that initiated the job.

  • Run from:

    • Location where the job was launched. Click the link to view details.

  • Status:

    • See Tabs above.

  • Started: Start timestamp for the job.

    • Scheduled jobs are indicated with an icon.

Actions:

  • Filter by status: Click one of the tabs to filter the display to show only the listings for the selected job status.

  • Filter by type and date: Click the Funnel icon to filter the list of jobs by source of execution, date range, or both. See below.

  • Search: Enter text in the search field to filter the listed jobs by job ID, flow name, or dataset name.

Context menu:

Next to the job listing, click the options menu to see the following:

  • Cancel Job: Select to cancel a job that is currently being executed.

  • Delete job: Delete the job from the platform.

    Warning

    Deleting a job cannot be undone.

    Note

    This feature may not be enabled in your instance of the platform. For more information, please contact your Alteryx Administrator. See Miscellaneous Configuration.

  • DownloadLogs: Download the logs for the job. If the job is in progress, log information is likely to be incomplete.

    Tip

    When jobs fail, the downloaded package includes additional configuration files and service logs to assist in debugging job execution issues. For more information, see Support Bundle Contents.

Additional options are available for each job. See Job Details Page.

Filter Jobs

To filter the list of jobs based on dates or source of execution, click the Funnel icon. You can use the following dialog to filter the display of jobs.

JobsPage-FilterJobs.png

Figure: Filter Jobs dialog

Job type:

Show jobs based on the following available options:

  • Show all jobs

  • Only show manual jobs

  • Only show scheduled jobs

Started:

  • Specify the date and time when the jobs to display began.

  • If needed, you can specify the start time as a range. Select Start Between from the drop-down list and populate both date-time rows.

Ended:

  • Specify the date and time when the jobs to display ended.

  • If needed, you can specify the end time as a range. Select Ended Between from the drop-down list and populate both date-time rows.

Actions:

  • To clear the time period values, click Clear Filters.

  • To apply the specified time filter to the Jobs page, click Apply.

In this section: