Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sadequl Hussain A Simple way of Automating Scripts RE: A Simple way of Automating Scripts

  • July 30, 2009 at 12:38 pm

    #1032610

    JJ B (7/30/2009)

    Nice article.

    The part of the process I don't like is having to name the scripts a certain way to get them to run in the correct order. Wouldn't changes to the order (needing to insert a script somewhere) end up being a pain? Of course, the article was clear that the script naming idea was just the simplest way to go.

    We do something similar to what Sadequl has done, and we do periodically have to insert a file in the middle of the run order. An easy way to accomplish that is to add characters to the end of the filename - ScriptB_1.sql. This would place the new file between ScriptB and ScriptC in the run order.

    Thanks,

    Chad