Here at my job I am looking to streamline a process that has been ongoing for 10 years. This is a monthly report that is created for another unit.
We open a SQL query called "SQL File Builder". In this query, there are 2 parameters that we have to change for the report, Month and Year. Today is mid May 2019 so we would put the local values as:
Reporting Year = 2019
Reporting Month = 4 (we run the previous month)
Once we execute the query, it results in a raw INSERT Script.
We copy the INSERT Script and paste it into a new query window and save the query (with appropriate name: Report052019_UnitA) in a common shared location for the other unit to grab.
My question is, would a Job solution be appropriate to streamline this process? How do I approach it?
Thanks in advance!