Hi,
I just want to check instead of using triggers, is there a way in event studio to stop the agent from executing reports once the condition is met?
My agent will run every hour. It will check if a database run flag is set to Y and date is today only then it will execute all tasks. But once it already ran for the day, I don't want it to execute the tasks again.
Thank you in advance.
Depends on what you're allowed to do in your environment. One solution might be to create a stored procedure that writes back to the database with a record/flag that the reports have been run - then have your event check for that flag. Have the stored procedure at the end of the report run.