Display Email Recipients on Scheduled Reports

Kinetic ERP
, ,
1

(Cloud)

Is there a way to view the email recipients on an SSRS report that has been scheduled to run on a specific schedule in System Agent?

I know I can view the Task Parameters in System Agent, but that does not include any info about the email properties (recipients, Subject, Body of email).

Since this is cloud, I have no way to look at the SSRS server directly to view report subscriptions.

2

Yes, you can look at table Ice.SysAgentTaskParam

1 Like
3

If you know the task number…do a BAQ against Ice.SysAgentTaskParam and look for Parameter Label “Email To”. I scheduled one to email myself every morning at 333a to make sure the System Agent was up and running…

image
image918Ă—76 22.1 KB

1 Like
4

It’s in the classic System Monitor though the BAQ ideas above are probably better

image
image986Ă—256 10.8 KB

5

Thanks, that got me on the right track! The description of that table points to another table for the actual values.

Ice.SysTaskParam lists the actual values of instances of the parameters, such as EmailTo, EmailCC, EmailBody, etc.

2 Likes
6

Sorry about that! I knew that there was a table with the values and at a quick glance, that looked to be the one.

7

No - you were correct. :slight_smile:
SysAgentTaskParam does include the actual values for the scheduled task. SysTaskParam contains the values that were copied from SysAgentTaskParam and used for each historical occurrence of that task.

3 Likes