Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Is there a way to list email recipients by schedule We woul...


Debra Waybright

Recommended Posts

Create connection to your repository

Create synonym for the for the following bot tables.

BOTSCHED

BOTDIST

BOTSIT

 

Email Schedules can have email address or distribution list. The blow code will help you get the emails.

JOIN

BOTSCHED.BOTSCHED.SCHEDULEID IN botsched TO MULTIPLE BOTSIT.BOTSIT.SCHEDULEID

IN botsit TAG J1 AS J1

END

JOIN

LEFT_OUTER BOTSCHED.BOTSCHED.SCHEDULEID IN botsched TO MULTIPLE

BOTDIST.BOTDIST.SCHEDULEID IN botdist TAG J0 AS J0

END

TABLE FILE BOTSCHED

PRINT

J0.BOTDIST.DISTDESC

BY BOTSCHED.BOTSCHED.JOBDESC AS Job

BY BOTSCHED.BOTSCHED.CASTER_USER AS User

BY BOTSCHED.BOTSCHED.ACTIVE NOPRINT AS Status

BY BOTSCHED.BOTSCHED.LASTEXSTATUS AS Job Status

BY J0.BOTDIST.DISTLIST

BY BOTSCHED.BOTSCHED.FULLDISTLIST

ON TABLE SUBHEAD

ReportCaster Schedules

WHERE ( BOTSCHED.BOTSCHED.ACTIVE EQ Y ) AND ( J0.BOTDIST.DISTDESC EQ Email );

ON TABLE SET PAGE-NUM NOLEAD

ON TABLE SET ASNAMES ON

ON TABLE NOTOTAL

ON TABLE PCHOLD FORMAT HTML

END

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...