How to run the sql scripts only once ?

Narendher Babu A

9y2.9k

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
Accepted 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.
+1
Gokhul Varman9y ago
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
-4