Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Ingestion and Replication
  • All Products

Table of Contents

Search

  1. Preface
  2. Database Ingestion and Replication

Database Ingestion and Replication

Database Ingestion and Replication

Back Next

Resuming a database ingestion and replication job

Resuming a
database ingestion and replication
 job

You can resume a
database ingestion and replication
 job that is in the Stopped, Aborted, or Failed state.
When you resume an initial load job that has multiple subtasks,
Database Ingestion and Replication
 starts only the subtasks that are in a Failed, Stopped, Aborted, or Queued state.
When you resume an incremental load job or a combined initial and incremental load job,
Database Ingestion and Replication
 resumes replicating source data change from the last position recorded in the checkpoint file or target recovery table. A checkpoint will not be available unless a change record was processed for at least one of the tables during the first job run after deployment. If a checkpoint is not available, the job resumes processing from the configured restart point, which is the latest available position in the change stream by default.
For initial load jobs, the
Run
 command might also be available. Click
Run
 if you want the
database ingestion and replication
 job to truncate all of the target tables and then reload the source data to the target tables.
  1. Navigate to the row for the job that you want to resume in any of the following monitoring interfaces:
    • My Jobs
       page that's accessed from the navigation bar of the Home page
    • All Jobs
       page in the Monitor service
    • All Jobs
       tab on the
      Data Ingestion and Replication
       page in
      Operational Insights
  2. In the
    Actions
     menu for the row, click
    Resume
    .
    The
    Resume
     command is not available if the job is in the
    Failed
     state because the task deployment failed.
    A subtask is started for each source table.
    If an error occurs, an error message is displayed at the top of the page.
0 COMMENTS
We’d like to hear from you!