HOW TO: List all unscheduled workflows in a PowerCenter repository
Solution
To list all unscheduled workflows in a PowerCenter repository do the following:
1. Run the following query which returns all the scheduled workflows in the repository:
select workflow_name, scheduler_name from rep_workflows where scheduler_name is not null;
2. Run the pmcmd command to get the currently scheduled workflows for each integration service connecting to the repository.
pmcmd getservicedetails -sv <Integration_service_name> -u <user_name> -p <password> -scheduled -d <domain_name>
3. The workflow names in step 1 which are not in step 2 are the unscheduled workflows, provided all workflows are scheduled initially.
