Can anyone assist me with the requirements for setting up the Jet Scheduler to email out reports. Where do the email settings go?
It appears that you may need to set up an email account in the user profile but I was hoping there was a better way more centralised way as we are scheduling the reports to run on a server using Teminal Services.
Regards,
Lloyd
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Lloyd,
Through our use of Jet reports, I have found the only way to email without using a users profile is to have a third part tool do the emailing. In this situation, I have used SQL server & Database mail. The problem here is there is no way of easily determining if the report has finished or not.
An alternate method could be using the 'batch' option within Jet scheduler and then a 3rd part mailing Exe, however I have never gone down that road before, and not 100% sure if its workable or not.
With the user profile thing, I have found that in our environment (Outlook with POP3/SMTP) we actually need to have Outlook open for the reports to get mailed. If you use an exchange server, you might be able to get away with:
1) Create a dedicated user account in your domain.
2) Login to terminal server interactively with the account that will run the reports
3) Setup mail profile.
4) Log off terminal server
5) Ensure you specify this account name when creating a scheduled report
6) Cross your fingers and hope!
Again, that's just guessing. Hope it helps. -
Jet Reports Historic Posts Thanks Mark,
Unfortunately with our setup the users log into a Terminal Server and schedule the reports (so that they can run during the evening when the database isn't busy) so Outlook could not be open all the time and we would like some sort of automated email such as the batch method you proposed.
I will investigate further and post any solution I find here.
Regards,
Lloyd -
Jet Reports Historic Posts As said, usually we let Outlook do the scheduling and have one user just for the scheduling (connection stays open).
The nice thing about this is that you can see all send e-mails…
I have to admit it has some downsides (not unattended).
Please sign in to leave a comment.