Automating Daily Reports with SQL Express
Recently, one of our customers who uses PeopleTrack to manage the time and attendance of their employees was looking to have a currently checked in report automatically sent to their email each morning. Unfortunately, in this case the customer was hosting their database using SQL Express, which does not have the capability (SQL server agent) to automate queries and tasks, unlike MS SQL server standard and our Cloud environment.
Fortunately, there is now a documented work-around available that can be used to have queries scheduled, and results emailed regardless of the SQL platform. By using your own mail server and utilizing the capabilities of Windows Task Scheduler, it’s surprising how much can be accomplished with the free versions of SQL.
For assistance setting up your own custom scripts, or to request automated reports, which are readily available for all our cloud customers, please contact us.