Jobs

Jobs

A pipeline execution is called a job; a job tracks the progress of imports, transformations, and exports in a pipeline, among other stats.

To navigate to the Jobs page, you can click the Jobs tab from the top bar menu.




The Jobs tab shows the list of all the jobs executed across all the workspaces in your organization along with the Job ID, the associated pipeline, start and run time, status, run by, storage used, and rows processed.

The jobs list can help you identify the failed pipeline jobs and give users a way to retry the jobs.




Filter:

You can use the filter dropdown to list the jobs by type: Manual run, Manual run with data(Manual run with refreshed data), Schedule run, Backfill run, Sectional run, Zoho Flow, WebhooksReload data and Code executions. To view sectional jobs, you can enable the Include Sectional Jobs toggle.




 You can also filter and search on the jobs using filter attributes such as run by, pipeline, workspace, status, and run time. Learn more.

 

You can also quickly sort your jobs based on pipelines, start time and status using the respective sort icons located at the top of the table header.

 

 


To learn more about pipelines and other entities in DataPrep, click here

  

Job Summary

Click on a job in the Jobs page to navigate to the Job summary. The Job Summary page displays key execution details of a job, including the Pipeline name, Job status, Run duration, Run by, Storage used, Total rows processed, Data interval, as well as the Start and End time of the job.


NotesNote: You can also choose the Job history option from the Pipeline builder page and navigate to the Job summary page.



This gives detailed insights into a specific job and visibility into how a pipeline performed from start to finish including overall status, individual stage outcomes, and exported results helping you troubleshoot issues, analyze performance, and verify output quality.

You can click Edit pipeline to modify your pipeline if a job fails or if changes are required. To view all the jobs executed in your pipeline, click the Job history option. 

The Job summary shows details of a job in three different tabs: Pipeline flow, Stages and Output. 

Pipeline flow

The Pipeline flow tab provides a visual representation of how the pipeline is executed for the selected job. It helps you understand the end-to-end flow of data through the pipeline and quickly verify whether each step was completed successfully. 

This tab displays the sequence of pipeline stages, starting from the import source, through the applied transforms, and up to the final export destinations. Each stage in the flow is shown with its execution status, allowing you to easily identify completed, failed, or skipped steps. You can also download all outputs together as a ZIP file using the Download all outputs option.





Click on a Stage in the Pipeline flow to view the rules applied on that particular stage.


 

Stages 

The Stages section in the Job Summary page provides a comprehensive view of how a job was executed across the different stages of the pipeline. It breaks down the execution into Import, Transform, and Export, presenting both a summary and detailed view of each stage. It includes details on the status, rows processed, storage used, start time and end time of the import, transforms applied, and export.




Import

The Import stage displays details of all data sources involved in the job. It shows the overall import status along with the count of successful and failed imports. For each source, the stage provides information such as the import status, number of files imported, number of rows imported, storage used, and time taken to complete the import. 


You can click the info icon to view the data source details. This will have the necessary details on the source of the input data which includes source type, parsing details, etc.

The View import configuration option gives you an overview of the import configuration of data sources.



You can click on the files imported link present next to the file name to open the Batch file popup. This displays a list of all the files imported in that batch along with the file name, storage used, and the number of rows imported for each file. You can also download individual files directly from this popup using the download icon.

Notes
Note: This option is available only for File, FTP, and cloud storage data sources.


Transform

The Transforms section shows a summary of all the transforms executed as part of the job run. It provides an overview of transforms and details such as data quality indicators, rows processed, storage usage, and processing time. This section helps you quickly monitor the progress of transforms and identify any failed steps that may require attention.



Click the info icon to view all the rules applied to the data. You can use the preview icon to quickly view the output data for that stage. You can also click the download icon to download the output data from that specific stage directly, without having to download all outputs together.



Export

The Export stage provides details of the final outputs generated by the job. It lists all export destinations along with their execution status, data quality indicators, number of rows exported, storage consumed, and time taken for each export. This stage allows you to verify that the processed data was successfully delivered to the intended destinations.



Click the info icon to view the destination details.  You can also use the Preview icons to quickly view the output at each stage and download the data from any stage if required.

Stage status

Here's the snapshot of the status you will see when a job is running.



Success - When a stage runs without any error, this status appears.

Not run- Some imports or stages may not run in cases of manual (existing data) or sectional runs, or when they are not a dependent upstream node. For example, during a sectional run, changes from upstream will be loaded into downstream, but no new imports will take place. As a result, the import stage will not run.

Notes
Note: The rows from these stages will not be counted for the rows processed calculation.

Cached- Some stages will be cached if the data has already been processed in a previous run, or when they are not a dependent upstream node for this run. For example, consider a pipeline with two independent stages, A and B. If you apply transforms only to A and run the pipeline, B will continue to use its existing data without any updates. In this case, B will be cached.

Notes
Note: The rows from the cached stages will not be counted for the rows processed calculation.

Queued- The next batch of processing stages will be added to the queue during a pipeline run.

Failure - When an erroneous stage fails, this status appears. 

Output 

In the Output tab, you can view the list of all outputs of the job along with the destinations added, data quality, output stage, rows exported, storage used, and time taken to export.  



You can click the info icon of each output to view the output details. You can also preview the output data and download the output.

FAQs

1. What should be done if the export fails due to dataset quality issues such as invalid values in the data?

If the export fails due to errors such as the ones below, the invalid values in your data must be fixed. 

1. Export was aborted since the dataset quality 100 is below the configured minimum quality 100. 
2. Export has failed due to invalid data present in your dataset, which is not accepted by the destination. 




Follow the steps to find the invalid values in the data:

1. Navigate to the Job summary ->Output tab.



2. Click the Data quality symbol to view the invalid columns.



3. After identifying the invalid columns, click the Edit Pipeline option on the Job Summary page and navigate to the Studio page. Use the appropriate transforms to correct the invalid values, then rerun the pipeline. 

4. Sometimes, the sample might not contain any invalid values, yet the full data will have them. In this case, please go to the last data preparation stage > In the right-hand side pane, click on the edit icon beside Sample Strategy > Select Errorneous sample and click Apply.



This will surface invalid values in your sample data. Please fix these invalid values and retry the job. 

2. Can we validate if there is no file before running the pipeline to avoid job failure?

In Zoho DataPrep 2.0, during incremental fetch, the pipeline job initiates regardless of whether the input file exists or not. If the file is missing, the job fails during the import stage. DataPrep handles such scenarios automatically, so no manual validation is required beforehand. You can view these failures in the job summary.




3. Why is the downloaded output file size larger than what’s shown in the Stages tab?

Zoho DataPrep stores files in a compressed form to optimize storage space. Because of this, the file size shown within DataPrep is smaller. When you download the output data, the file size will be much larger. For example, a file that uses 1 GB of storage in DataPrep may occupy more space once downloaded as output.

SEE ALSO

How to create a new pipeline?

How to create a pipeline from templates library?

Learn about manual run

Learn about schedule run

Learn about backfill run



        Create. Review. Publish.

        Write, edit, collaborate on, and publish documents to different content management platforms.

        Get Started Now


          Access your files securely from anywhere

            Zoho CRM Training Programs

            Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

            Zoho CRM Training
              Redefine the way you work
              with Zoho Workplace

                Zoho DataPrep Personalized Demo

                If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

                Zoho CRM Training

                  Create, share, and deliver

                  beautiful slides from anywhere.

                  Get Started Now


                    Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                    BOOK A SESSION







                                Quick LinksWorkflow AutomationData Collection
                                Web FormsEnterpriseOnline Data Collection Tool
                                Embeddable FormsBankingBegin Data Collection
                                Interactive FormsWorkplaceData Collection App
                                CRM FormsCustomer ServiceAccessible Forms
                                Digital FormsMarketingForms for Small Business
                                HTML FormsEducationForms for Enterprise
                                Contact FormsE-commerceForms for any business
                                Lead Generation FormsHealthcareForms for Startups
                                Wordpress FormsCustomer onboardingForms for Small Business
                                No Code FormsConstructionRSVP tool for holidays
                                Free FormsTravelFeatures for Order Forms
                                Prefill FormsNon-Profit

                                Intake FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile Forms
                                Card FormsFoodOffline Forms
                                Assign FormsPhotographyMobile Forms Features
                                Translate FormsReal EstateKiosk in Mobile Forms
                                Electronic Forms
                                Drag & drop form builder

                                Notification Emails for FormsAlternativesSecurity & Compliance
                                Holiday FormsGoogle Forms alternative GDPR
                                Form to PDFJotform alternativeHIPAA Forms
                                Email FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG

                                  Zoho FSM Video Tutorials


                                        All-in-one knowledge management and training platform for your employees and customers.

                                                  Create. Review. Publish.

                                                  Write, edit, collaborate on, and publish documents to different content management platforms.

                                                  Get Started Now




                                                                    You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                                        Manage your brands on social media


                                                                          • Desk Community Learning Series


                                                                          • Digest


                                                                          • Functions


                                                                          • Meetups


                                                                          • Kbase


                                                                          • Resources


                                                                          • Glossary


                                                                          • Desk Marketplace


                                                                          • MVP Corner


                                                                          • Word of the Day


                                                                          • Ask the Experts


                                                                            Zoho Sheet Resources

                                                                             

                                                                                Zoho Forms Resources


                                                                                  Secure your business
                                                                                  communication with Zoho Mail


                                                                                  Mail on the move with
                                                                                  Zoho Mail mobile application

                                                                                    Stay on top of your schedule
                                                                                    at all times


                                                                                    Carry your calendar with you
                                                                                    Anytime, anywhere




                                                                                          Zoho Sign Resources

                                                                                            Sign, Paperless!

                                                                                            Sign and send business documents on the go!

                                                                                            Get Started Now




                                                                                                    Zoho TeamInbox Resources





                                                                                                              Zoho DataPrep Demo

                                                                                                              Get a personalized demo or POC

                                                                                                              REGISTER NOW


                                                                                                                Design. Discuss. Deliver.

                                                                                                                Create visually engaging stories with Zoho Show.

                                                                                                                Get Started Now








                                                                                                                                    • Related Articles

                                                                                                                                    • Zoho DataPrep Rest APIs

                                                                                                                                      The Zoho DataPrep Rest APIs workspace hosted on Postman, represents Collections curated by the Zoho DataPrep team. Our workspace serves as a comprehensive hub for developers looking to leverage the full potential of Zoho DataPrep's APIs. Write to us ...
                                                                                                                                    • Zoho DataPrep REST APIs for White Label Edition

                                                                                                                                      Zoho DataPrep White Label REST APIs make it easy for independent software vendors, solution developers, and business consultants to integrate powerful ETL and data preparation capabilities directly into their own products. By enabling a seamless, ...
                                                                                                                                    • Pipeline sectional run

                                                                                                                                      When data propagation happens in a pipeline, the changes made in the upstream stages are loaded to the current stage that you're working on. This runs a section of a pipeline and therefore called Sectional runs. What is data propagation? Data ...
                                                                                                                                    • Create a new pipeline

                                                                                                                                      Pipelines are fundamental entities that allow users to create ETL pipelines / data flows in DataPrep, with multiple data stages and using various flow‑level transforms. You can create a new pipeline from scratch (for your data integration and data ...
                                                                                                                                    • Dataiku connector for Zoho DataPrep

                                                                                                                                      Zoho DataPrep allows you to bring in data from Dataiku, an end-to-end platform designed for data science, machine learning, and artificial intelligence (AI) that helps organizations design, deploy, and manage data and AI projects. With this ...
                                                                                                                                      Wherever you are is as good as
                                                                                                                                      your workplace

                                                                                                                                        Resources

                                                                                                                                        Videos

                                                                                                                                        Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                                        eBooks

                                                                                                                                        Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                                        Webinars

                                                                                                                                        Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                                        CRM Tips

                                                                                                                                        Make the most of Zoho CRM with these useful tips.



                                                                                                                                          Zoho Show Resources