Comments for SQL 2 Excel Pro - Scheduler at http://www.joomla-r-us.com , comment 1 to 9 out of 9 comments http://www.joomla-r-us.com Sat, 04 Feb 2012 17:26:39 +0100 FeedCreator 1.7.3 http://www.joomla-r-us.com/faq/102-sql-2-excel-pro-scheduler#comment-502 @Richard Southern: You do need to trigger the schedule handler with a cron job in order for it to work automatically. More info: Using the Scheduler [url]http://support.joomla-r-us.com/categoryblog/52-sql-2-excel-pro-using-the-scheduler[/url] SQL 2 Excel Pro Support Forum [url]http://support.joomla-r-us.com/forum?func=showcat&catid=5[/url] -Mats - Mats @ Joomla-R-Us Sun, 28 Nov 2010 05:23:34 +0100 http://www.joomla-r-us.com/faq/102-sql-2-excel-pro-scheduler#comment-501 Hi, I have set up a schedule job but it never seems to run, someone said I would need to set up a Cron job to enable this to work. Is this correct or should your scheduler run the job once setup. Thanks in advance Richard - Richard Southern Sun, 28 Nov 2010 02:57:41 +0100 http://www.joomla-r-us.com/faq/102-sql-2-excel-pro-scheduler#comment-500 Hi, I have set up a schedule job but it never seems to run, someone said I would need to set up a Cron job to enable this to work. Is this correct or should your scheduler run the job once setup. Thanks in advance Richard - Richard Southern Sun, 28 Nov 2010 02:57:39 +0100 http://www.joomla-r-us.com/faq/102-sql-2-excel-pro-scheduler#comment-369 @Ernie de: In SQL 2 Excel Pro you can one or more schedules which can perform tasks such as send an email with/without Excel attachment. Which email(s) that you send the email to can be hardcoded, or it can be specified using a SQL query. I don't have any examples, but it's as simple as typing a SQL query which returns a list of email addresses into the TO, CC, BCC fields. For example: TO: SELECT email FROM jos_content WHERE created - Mats @ Joomla-R-Us Sat, 24 Jul 2010 10:36:10 +0100 http://www.joomla-r-us.com/faq/102-sql-2-excel-pro-scheduler#comment-368 GREAT tool, btw.... Do you have an example available to show how you would have the Scheduler run an SQL Query to gather a list of emails to send the report/link/whatever to? - Ernie de Sat, 24 Jul 2010 02:29:41 +0100 http://www.joomla-r-us.com/faq/102-sql-2-excel-pro-scheduler#comment-367 How do you specifiy which emails a particular scheduler item is to use to send out the emails? - Ernie de Sat, 24 Jul 2010 02:21:34 +0100 http://www.joomla-r-us.com/faq/102-sql-2-excel-pro-scheduler#comment-356 @Calagan: Yes, you can define a schedule to send an email with an attached Workbook (containing one or more Worksheets). The schedule can be setup so that the email goes out monthy, weekly, daily, or even any custom interval. When the schedule is triggered, the Worksheets are generated dynamically from the SQL queries and the resulting Workbook is attached to an email that is sent to the specified recipient(s). -mats - Mats @ Joomla-R-Us.com Fri, 09 Jul 2010 13:42:30 +0100 http://www.joomla-r-us.com/faq/102-sql-2-excel-pro-scheduler#comment-355 Hi,"•Send emails with attached Excel Spreadsheets." does it mean that you can schedule a query (in a worksheet) to be executed every month and receive the result of the query by mail ? Thanks - Calagan Fri, 09 Jul 2010 00:00:17 +0100 http://www.joomla-r-us.com/faq/102-sql-2-excel-pro-scheduler#comment-343 This feature alone is worth the price - 5 times!! - jcloe Thu, 17 Jun 2010 16:00:10 +0100