1. I have created a new table called Email_TimeNotifications. It has the Frequency, Name, Active and Path. I have added a record to it.
2. I added a udb_property of TN_RecordTypes = "Email_TimedNotifications".
3. I created a Email_Notification_Rule - on RecordType = "Email_TimedNotifications"
Action=DailyNotifications,
Condition = "$Frequency eq "Daily"
Subject = "ClearQuest - $name"
Body = "<HTML><BODY>
<H2 ALIGN="Center">$name</H2>
RETURN_QUERY_RESULTS_AS_HTML_TABLE($Path)
</BODY></HTML>
***** To = When I put ES_GetSubscribersEmails() I get an error that this cannot be found. If I put a email address it works.
To execute it I use: cqperl timedNotification.pl foo "" BETSX XX DailyNotification