How to run the sql scripts only once ?

Question

For eg. If a table has 1 lakh records. If i run the script it will update the 1 lakh records. Now if i run the script again it should not execute becouse it was already executed and also the table should not update? please help

Nilesh Shah · Answer

by default there is no statement/mechanism in SQL server which can do this. you need to identify some condition based on which you want to decide if the script is run or not. let's say you want to execute only once in 24 hours then you can have a table which store last timestamp when thequery was executed. in your query in very first line you chech this table if that timestamp is less than 24 hours then query exits without doing anything. similarly you can write logic for hourly or weekly or monthly one time execution. if you want to execute the script only once in life time then store some boolean value in a table mark it true in first execution check if it's true then script should not execute.

Gokhul Varman · Answer

if you refer the link you can get a clear solution about your problem:http://forums.pentaho.com/showthread.php?53918-How-to-run-custom-sql-statment-only-once-in-Execute-Sql-Script-step-in-transformation