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.
Hi,
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
Thanks,
Karthik
Here's a script I run on Linux. It outputs to PDF, then attaches that to an email. (Needs uuencode).
JAVA="/path/to/java" CLW="/path/to/CLWorkstation.jar" 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") OUTPDF="output.pdf" SENDER="sender@email.com" RECIPS="recip@email.com" 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.