Creating an Agent

[jguevin]

Here's the scenario...I have a table of data that is created every month.  I need to send an email to folks on a monthly basis that shows this table only when data within the table changes.  Now the time frame it must be sent is within the first 5 business days of the month.  Can anyone offer any suggestions?

Thanks
Jeff

[praveennb]

If you are using SQL Server then you could write a stored procedure to update a table  to set the value to True when business days =5th of the month , then publish the table using framework manager then use this field in the event studio.

or

you could build the same functionality using the framework manager, by manually adding the SQL statements to build the query subject.

Hope this helps, let us know.

[mikewalker]

1. Create an Agent,
2. Put your data conditions into the criteria area,
3. Also include the statement AND TO_CHAR({sysdate}, 'DD') >= 5,
3. Set the Agent to run only on "Changed" events, then
4. Schedule the Agent to run every morning.