Focal Point
Caster question ..how to extract the scheduleid from the running schedule

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3851072541

December 21, 2005, 04:07 PM
susannah
Caster question ..how to extract the scheduleid from the running schedule
anybody know how to extract the schedule id from the current running schedule?
the way &FOCFOCEXEC gives the name of current fex. I want to use Jodye Yates's cool method for postponing a caster sched, but i want to do it generically, grabbing the schedid from the caster job..('cause every wee change you make to a caster job changes the schedid)




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 22, 2005, 03:27 AM
Tony A
Susannah,

Just a quick throw away suggestion - but have you tried just having -? & in a castered fex to trap the variables?

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
December 22, 2005, 09:13 AM
susannah
i can't see anything in a caster log if the echo is on, it won't log the job at all.
i'm looking for maybe some secret && i can elevate to active, like &&IBI_IF_FLDS, or some extraction function. I've got Jodye's caster update method working, i just wanna bullet-proof it.
Live, i get this:
CURRENTLY DEFINED & VARIABLES:
&&IBI_IF_FLDS = d:\ibi\apps\excludef.fex
&ACCEPTS = 0
&APPROOT = D:\ibi\apps
&AUTOINDEX = NO
&BASEIO = 0
&CHNGD = 0
&DATE = 12/22/05
&DELTD = 0
&DMY = 221205
&DMYY = 22122005
&DUPLS = 0
&ECHO = OFF
&EXITRC = 0
&FOCEXURL = /ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERV
&FOCFOCEXEC = _ADHOCRQ
&FOCHTMLURL = /ibi_html
&FOCINCLUDE = ADHOCRQ
&FOCNEXTPAGE = 0
&FOCREL = R720527B
&FORMAT = 0
&IBIF_wfdescr>= OFF
&IBIMR_user = admin
&INDEXIO = 0
&INPUT = 0
&INVALID = 0
&LINES = 0
&MDY = 122205
&MDYY = 12222005
&NOMATCH = 0
&READS = 0
&RECORDS = 0
&REJECTS = 0
&RETCODE = 0
&SETFILE =
&SORTIO = 0
&TOD = 08.59.40
&TRANS = 0
&WFDESCRIBE = OFF
&YMD = 051222
&YYMD = 20051222




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 22, 2005, 09:22 AM
Francis Mariani
I haven't been working with Caster for a while so I'm beginning to forget some stuff, but I think the only way you can determine the Sched ID is to read the appropriate Caster repository table...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 22, 2005, 10:57 AM
susannah
that's what i would be doing, within the fex, in order to update the nextruntime. But i'ld like to determine the schedid without having to hardcode it.
MODIFY FILE BOTSCHED
MATCH SCHEDULEID
ON MATCH UPDATE NEXTRUNTIME
otherwise go home.
Thing is, the schedid changes if you make some modifications to the job, so i don't want to have to remember to re-figure out the new id, and then edit the modify part of the job.
It all works ok now, hardcoded.
But i wanna bullet-proof it.
Moderators...can you get Vincent Lam to log in and tell us how to do this? gracias.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
January 13, 2006, 07:17 PM
jodye
Hi Susannah

Did you ever get this to work? I posted the exact same question a while ago... and never got an answer. Then I realized that I could simply lookup the scheduleid based on the jobdesc. So if you have access to the jobdesc as a parameter then you are all set.


WF 8.0.0.5M
January 14, 2006, 02:42 PM
susannah
hmm. what i think i meant was...the way you can extract the userid from a fex-in-action, i wanted to extract the schedule id from a caster-job-in-action. caster changes the schedule id wheneve ryou make changes to the job in some way..and i didn't want to have to keep track manually. i don't want to have to look up by job name...because i don't have the job name either when i'm running...and its a character string, which i'm not fond of using as a lookup..whereas skedid is a nice contiguous fixed-size thingy.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
June 12, 2007, 11:12 AM
<Barry>
Try &DSTSCHEDID in the focus procedure.