I have an automation file that needs to get three parameters from the user: :FirstDate, :LastDate and :YourEmail. The job then runs four select to file jobs which are supposed to use the the FirstDate and LastDate to get activity counts for the date range. Then send an email with each of the results.
When I run the automation, I get an error stating "Set_Variables - Object Reference not set to an instance of an object. Object Reference not set to an instance of an object."
What am I doing wrong?
Each script is: SELECT CAST(TrxDate AS DATE), SUM(Revenue), COUNT(*) FROM MyTable1 WHERE TrxDate >= :FirstDate AND TrxDate<=:LastDate GROUP BY CAST(TrxDate AS DATE) ORDER BY CAST(TrxDate AS DATE) DESC;