I have read a lot of the forum and can’t see this question asked (or answered) so apologies if this is a common question.
I have a script that runs every morning that pulls in all of the data from the database for a number of client IDs. We gain new clients all the time and therefore I am required to add these IDs into the script. However, when I update the script the .tas doesn’t update automatically and still uses the old script so I have to rebuild the .tas file.
Is there a way so that I don’t have to do this and the automation can just look at the updated (.sql) script?