Hello,

I am trying to get the Connection between the Tasks used in the schedulers and the schedulers.

In botlog2 I get the Tasks by rc_message like 'WebFOCUS ...'
and the stat_bt_Name, which I can join with botlog's stat_bt_nmae, sowthat I get the scheduleid and with wf_reposobj the Schedulername.

But somehow it does not really work, because of the join between the stat_bt_name's from botlog2 and botlog...
select --taskobj,
--sched_id,
--prt_path,
substr(FexName, 1, INSTR(FexName,'.',5)-1) as FexName,
FexPfad,
substr(ZeitplanName, 1, INSTR(ZeitplanName,'.',5)-1) as ZeitplanName,
ZeitplanPfad
from
(select distinct substr(a.rc_message,INSTR(a.rc_message,'/',5,Length(a.rc_message)-Length(Replace(a.rc_message,'/','')))+1) as FexName,
substr(a.rc_message,39) as FexPfad,
c.objname as ZeitplanName,
substr(c.prt_path,16) as ZeitplanPfad
--,a.taskobj, b.sched_id, c.prt_path
from webfocus.botlog2 a
left join webfocus.botlog b
on a.stat_bt_name = b.stat_bt_name
left join webfocus.wf_reposobj c
on c.handle = b.sched_id
where a.rc_message like 'WebFOCUS Report%'
)


can someone tell me a SQL or webfocus Report were I can find the Tasks used in´the schedulers??

Thanks

This message has been edited. Last edited by: FP Mod Chuck,

Hi Jenni,

Look at the table BOTTASK. TASKOBJPATH is the column I think you want.

T

Hi Tony A,

there is noh Taskobjpath, only taskobj.
But I want to join it sothat I get the fexname which is used in a Scheduler, and the schedulername with path.
My SQL works, but it doesn't match all the schedulerid's.

Hi Jenni,

Below is a screen grab of the BOTASK table within my local WF 8.2.01 report caster tables.



T

That must be a new field in 8.2.0x as it does not exist in 8.1.05.

Jenni

You should probably open a case with techsupport on this.