Hello,

I created multiple jobs that are similar. The only difference is the parameter I'm passing in. Is there a way to update a certain property in the jobs (e.g. editing distribution list) behind the scenes so I do not have to go to each job and change the distribution.

I looked at the different tables in Report Caster and I see the column names but I can only create fex file to report those...not sure how to modify.


Any input is appreciated.

This message has been edited. Last edited by: <Kathryn Henning>,

If the report output is exactly same for all the jobs then you can use multiple email addresses to the same schedule. If it is library I think it will take only 1 location.

We have a similar scenario but not on the distribution options, I have created a utility to update the parameter values by updating the underlying BOT tables. May be IBI doesn't recommend touching the BOT tables but the utility works fine for us.

If the code you want to update is common to many reports you could put it into a separate FOCEXEC and -INCLUDE it.

All reportcaster Jobs are controlled by the BOT* tables. by inserting records into these tables you could essentially copy your job and create multiple ones without going into reportcaster. I would recommend studying and understanding those tables first before doing so though. I have done the same thing as Rao in the past and it worked well.

I would suggest looking into bursting though. It sounds like you could make that parameter you pass a BY field in the report and then distribute to different lists accordingly.

Thank you everyone for the advice. I was able to do my updates on the BOT* tables in our SQL server. It worked well..

Eric, I was looking into bursting but I'm not sure how to set up the job and pass in different parameter in my task. I have multiple tabs for each Report caster job. I tried using the BY field and that didn't work for what I'm doing.