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
  • PowerCenter 10.4.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Appendix A: Session Properties Reference
  17. Appendix B: Workflow Properties Reference

Workflow Basics Guide

Workflow Basics Guide

Back Next

Scheduled States

Scheduled States

The scheduled state of a workflow includes historical run-time information such as the last time the workflow ran and how many times a repeating workflow has run. A workflow can get removed from the schedule based on changes to the workflow status or the Integration Service state.
When a workflow is removed from the schedule, the Integration Service either discards or maintains the scheduled state. If the Integration Service discards the scheduled state, it resets the state when the workflow is rescheduled. If the Integration Service maintains the scheduled state, it restores the state when the workflow is rescheduled.
When the Integration Service resets the scheduled state, it maintains the scheduler configuration. It does not check for missed schedules, and it schedules the workflow as though the workflow never ran. For example, you configure a workflow to run five times, and it stops during the second run. When you reschedule the workflow, the Integration Service resets the schedule to run five times.
The Integration Service can restore the scheduled state of a workflow in a highly available environment when it successfully recovers a terminated workflow or when you restart a workflow. When the Integration Service restores the scheduled state, it reschedules the workflow based on the scheduler configuration and the schedule frequency.
The Integration Service maintains or discards the scheduled state based on the following situations:
You disable a workflow.
When you enable a workflow, the Integration Service resets the schedule.
You remove a workflow from the schedule.
When you reschedule a workflow, the Integration Service resets the schedule.
You change the schedule settings.
The Integration Service reschedules the workflow according to the updated settings. If you change a schedule that is configured to run at repeated intervals, the Integration Service resets the frequency counter.
You copy a folder.
The Integration Service resets the schedule for all workflows in the folder.
You choose a different Integration Service to run a workflow.
The Integration Service resets the schedule for the workflow if it is unscheduled or is scheduled to run continuously but the start time has passed. You must reschedule the workflow if the start time is passed and the workflow is not scheduled to run continuously.
You recycle the Integration Service or enable it in normal mode.
The Integration Service resets the schedule for all workflows that are unscheduled or are scheduled to run continuously but the start time has passed. If a workflow is not configured to run on service initialization, you must reschedule it if the start time is passed and it is not scheduled to run continuously. If a workflow is configured to run on service initialization, you do not need to reschedule it.
You enable the Integration Service in safe mode.
In safe mode, workflows remain scheduled, but the Integration Service does not run them, including workflows that are scheduled to run continuously or run on service initialization.
A workflow becomes suspended.
A workflow can become suspended when you configure it to suspend on error. The Integration Service removes a suspended workflow from the schedule and it maintains the state of operation. You can recover a suspended workflow to restore the schedule.
A workflow fails.
To re-establish the schedule, you can reschedule the workflow. In a highly available domain, if you restart the workflow, and the workflow succeeds, the Integration Service restores the scheduled state and determines whether a scheduled run was missed.
A workflow stops or aborts.
To re-establish the schedule, you can recover or reschedule the workflow. If the domain is not highly available, the Integration Service resets the schedule. If the domain is highly available, the Integration Service restores the schedule. If you restart the workflow, and the workflow succeeds, the Integration Service restores the scheduled state and determines whether a scheduled run was missed.
A workflow terminates.
The Integration Service terminates all running workflows when it shuts down unexpectedly. If the domain is not highly available, the Integration Service resets the schedule when you reschedule the workflow. If the domain is highly available, and the workflow is recoverable, you can recover the workflow to restore the scheduled state. If the workflow is not recoverable, you can reset the schedule by rescheduling the workflow. If you restart the workflow, and the workflow succeeds, the Integration Service restores the scheduled state and determines whether a scheduled run was missed.
If you manually start a failed, terminated, stopped, or aborted workflow in a highly available domain, Informatica recommends that you unschedule it first. If you do not unschedule the workflow, and the Integration Service detects that the scheduled run time was missed, it immediately runs the workflow again. This can result in errors such as key violations and invalid data. When you unschedule the workflow first and reschedule it after the manual run completes, the Integration Service does not run the workflow based on the missed schedule.
0 COMMENTS
We’d like to hear from you!