Can we schedule Report template for any specific time so that people can get that report
There is a FieldPack from Chris Kline or you can create your cron job or Windows Scheduler task.
You can schedule reports but not directly from workstation. You need to write a script which access CLW workstation to run the reports. Then use cron job to schedule this script.
By this way, you should be able to run reports
Here's a script I run on Linux. It outputs to PDF, then attaches that to an email. (Needs uuencode).
START=$(date --date -$1day +"%Y-%m-%d 08:00:00")
END=$(date +"%Y-%m-%d 20:00:00")
CURRENT=$(date +"%Y-%m-%d %H:%M:%S")
QUERY="generate report named \"Report Name\" in management module named \"MGMT Module Name\" starting at \"$START\" ending at \"$END\" to $OUTPDF"
$JAVA -Dintroscope.clw.tt.console=true -Duser=username -Dpassword=password -Dhost=emhost -Dport=emport -jar $CLW "$QUERY"
(printf "%s\n\n%s\n" "Line of email Body" "Auto Generated at $CURRENT"; uuencode $OUTPDF $OUTPDF;) | mailx -s "Email Subject" $RECIPS -- -f $SENDER
Just as a reminder, anytime you use CLW and pass username and password, that information is sent cleartext on the wire.
If there's a security concern, use '-Dkeyfile=<workstation_home>/config/internal/console/EM.public' in place of both.
Retrieving data ...