I am looking for a report that will list all my tasks where the "Disable this task" box is checked.Does anyone know if a report like this exists, if not how can I create in Data Analyzer?
Are you looking to show Disabled tasks from PowerCenter OR Data analyzer tasks?
Below query gives all the tasks that are disbled. tasks include worklet,workflow,session,command,start etc..
To get only for disabled sessions,put extra filter condtion.
select * from REP_ALL_TASKS where is_valid='1' and is_enabled='1'
-- for disabled sessions add task_type='68'