Hi all, i wrote this code to get the next execution time:--\DEFINE FILE BOTSCHED TEMP1/A13 = SUBSTR(32,NEXTRUNTIME,18,29,12,TEMP1); TEMP2/D13 = EDIT(TEMP1); ICASTERBASE/I8YYMD WITH NEXTRUNTIME = 19700101; CASTERBASE/YYMD = ICASTERBASE; CASTERBASEDTM/HYYMDIA = HDTTM(CASTERBASE,8,'HYYMDIA'); FOCUSDATE/HYYMDIA =HADD(CASTERBASEDTM,'MILLISECONDS',TEMP2,8,'HYYMDIA'); -*GET THE TIME PORTION WITH TODAYS DATE TODAYDATE/YYMD=&YYMD; TODAYDATE2/A8YYMD=TODAYDATE; TODAYDATE3/A14=TODAYDATE2 | STARTTIME; SHOULD_BE/HYYMDS = HINPUT(14, TODAYDATE3, 8, 'HYYMDS'); END
-******************************************************* -*TABLE FILE -******************************************************* -*GET THE SCHEDULE INFO TABLE FILE BOTSCHED PRINT TEMP1 TEMP2 ICASTERBASE CASTERBASE CASTERBASEDTM FOCUSDATE SCHEDULEID NEXTRUNTIME FOCUSDATE TODAYDATE TODAYDATE2 TODAYDATE3 STARTTIME END
now i want to know for what fields i need to apply the filter criteria so that i need the report caster report that will be automatically sent to me when a user schedules a job between 1pm to 2pm on monday only.This message has been edited. Last edited by: Kerry,