The file we are taking about here is just the trigger file. This file will not be moved or renamed or deleted. Basically this file will tell me datawarehouse load is complete. So, once trigger file is present, I need to execute my job only once. Am I making sense?
trigger files are evil.. mmmkay?
that aside.. even if you dont need to do anything with it.. if you DON'T do something with it.. then you'll only ever be able to run the job once..EVER.. because you only want to kick this job off when the file exists. If this is just a once in a lifetime thing.. i wouldn't go to all this work.. just manually kick it off?
best practice here would be to move the file into an archive folder if you absolutely must keep it.. but if its just a trigger.. delete the dang thing.. you dont need it?
I long for a job where my databases dont have any pesky users accessing them