Tuesday, April 17, 2012

How to deliver an agent on first day of the month?

Create a request.

Select (*) from TABLE where (select next_day(trunc(sysdate,'month'),'mon') from dual) = sysdate

This will return null except for when its first day of the month.

Set an ibot as as condition of this, to only run when the report shows data.


Until Next Time... :)

No comments:

Post a Comment