I need help on scheduling a ReportCaster job using DSTRUN. I need to know how and where I need to execute the code.

Try the "ReportCaster API Developer’s Reference, Version 7 Release 1.3" manual.

Here's an example from Appendix A "ReportCaster API Subroutines: Running a Scheduled Job Using the DSTRUN Subroutine" in the manual:

-SET &var_name=DSTRUN(srv_userid,srv_userid_length,
- ‘srv_userpass’,srv_userpass_length,
- ‘hostname_port’,hostname_port_length,
- ‘scheduleid’,scheduleid_length,
- ‘jobdesc’,jobdesc_length,
- priority,
- ‘owner’,user_length,
- ‘parm’,parm_length,
- ‘ httpuser/pswd’,httpuser/pswd_length,
[- ‘tcpiplevel,’]
- 'I4');

Thanks Francis. I'm not sure where I can run the code though. Can I post to this fex (that has this code) from a selector page I have or does this have to be run through the command line?

This is a Dialogue Manager -SET command - it can run in any fex.

Great. When I run the fex, it gives me this:

No HTML Output!

EDA no data

Does this mean that it ran successfully, but did not return any data?

Thanks.

I have to say that DSTRUN is a little esoteric, getting it to work the first time is near impossible.

Here's a couple of discussions worth looking into:
DSTRUN Questions
DSTRUN gives Servlet Execution Error

to see if it ran check the log for the job you were hoping to get invoked via the DSTRUN.

Ira
aix 533 wf 5.3.7

I tested the sample code and found it only works when I run DSTRUN for an existing schedule, not for a fex (or "jobdesc") and I'm not sure what's wrong - I get a 112 error, you cannot have both a schedule id and a jobdesc, I tested with a blank shedule id and 0 length...

DSTRUN works only with an existing schedule. What I do is set up the schedule. On the Schedule tab, make sure the "Enabled (Sheduled job runs at specified time)" is unchecked. This disables the schedule.

To run the schedule, run the following:

-* File rc_submit.fex
-*
-* This job tell Report Caster to resubmit the desired job for
-* immediate execution.
-*
-* The only parameter is the Report Caster schedule id
-*
-* To use this in a fex, do the following
-* -SET &RCJOBID=scheduld_id;
-* -INCLUDE rc_submit
-*
-* To use this in Report Caster, add the following in the pre or post processing fex
-*   baseapp/rc_submit RCJOBID=schedule_id
-*
-SET &SUBERR=
-  DSTRUN('eda', 3,                    (1)
-         'zzzzzz', 6,                 (2)
-         'kids', 4,                   (3)
-         '&RCJOBID.EVAL',12,          (4)
-         ' ', 0,
-         3,                           (5)
-         'admin', 5,                  (6)
-         ' ', 0,
-         'okdhs\m73000/yyyyyyyy', 21, (7)
-         0,'I4');
-IF &SUBERR EQ 0 GOTO NO_ERROR;
-INCLUDE DSTRUNER
 FILEDEF SUBLOG DISK &&BASEAPP&RCJOBID...ftm
-RUN2
-WRITE SUBLOG &JOBID &SUBERR
-RUN
-NO_ERROR

where:
(1) and (2) are valid login id and password for the Reporting Server;
(3) is the ip/dns name of the web server where RC lives
(4) is the schedule id
(5) is the job priority
(6) is the owner of the schedule
(7) is a user id and password for the web server. the id also has to be a RC user id.

Hope this helps. Getting #7 right was the hard part for us.

John,

Thanks for the explanation. For some weird reason, looking at old code of mine, I thought jobdesc was fexname.

Cheers,

Francis.