שליפה מתוך ה-Repository למציאת WF מתוזמנים

HOW TO: Query a repository to find Workflows that use a scheduler

Solution   

If you query the REP_WORKFLOWS view, you can retrieve the workflows that use a scheduler. Following is the query:

select workflow_name, scheduler_name
from rep_workflows
where scheduler_name is not null;

Following is the Workflows query for reusable schedulers:

select workflow_name, scheduler_name
from rep_workflows
where scheduler_is_reusable = '1';
Following is the Workflow query for a particular name:

select workflow_name, scheduler_name
from rep_workflows
where scheduler_name = '<scheduler name> '