I am trying to schedule a report to run in SQL Server 2005 Express. I realize that the SQL Agent is not included and scheduling is more or less not possible. Is there any way to fire a report and export it via an SQL statement?
My plan is to write some SQL which executes a report, save the SQL and access it thru windows task scheduler and SQLCMD.exe. I am currently doing this with my scheduled backups and other maintenance scripts. But I need to be able to schedule a report as well.