My production report machine was replaced with a better machine and the database objects were scripted, including the SQL Agent jobs that were executing reports from SQL Server Reporting Services. The SQL Agent jobs are running but they are no longer
sending the reports via e-mail. How do I get the jobs to send the reports to an e-mail address without going back through the process of deploying the reports to the Report Manager on the new server?
I'm running SQL Server 2005 Standard on a Windows Server 03 machine.
View Complete Post