Is there a known synonym model to properly join the ReportCaster tables (BOT...)? I want to attempt to report on report caster jobs and would rather use a known model than attempt to come up with one on my own.

If this helps, here is what I am trying to do: If a report caster job runs, we can have it notify us if it fails or even if it runs. However, if the report caster job fails to run at it's "next scheduled time", there is no notification. We just had a case where a bunch of report caster jobs hadn't run for a couple days and we didn't realize it. I restarted the reportcaster service and they ran right away. However, since they didn't run and thus didn't "fail", we had no notification. I'm going to attempt to create an alert that will notify us if a job was "supposed to run" but didn't (like if [current date/time] > [next run time for a given job] ). But to do this, I need to join the report caster tables.

Thanks.

This message has been edited. Last edited by: Scott Matson,

Your Repository should be some kind of SQL database (our is MSSQL). As long as you have a WebFOCUS Adapter that will read the database, you should be able to create a connection to the repository just like you do for any other data source. Once you have that, you can build your synonyms.

Hi Scott,

The two main tables that you might want to consider are BOTSCHED and BOTTASK - join them on PACKETID.

I would normally make BOTTASK the parent so that you have a many-to-one join rather than one-to-many.

Good luck

T