Okay, so I am having a brain fade moment. I need to create a yearly agent to remind a db admin to perform an action on a database. I have the agent created that sends out the email, however, the agent will not let me schedule yearly. How do you schedule an agent to run yearly? Thanks.
Subject: Yearly Agent
Easy, you can’t.
Run a monthly agent and have it check the current date to determine, if it should exit immediately or perform its desired action. Alternatively, you could store the last execution time in a convenient place (profile document, envrionement …).
Subject: RE: Yearly Agent
Sorry, but I don’t understand…Where exactly would you put this code in, say a simple Newsletter Agent?
Thanks!
Subject: Yearly Agent
check whether the current date is the date that agent has to be run.if so run the agent.so the agent only runs when the date condition gets succeded.