I have SP with two conditions true and false. Its taking false condition if i run the procedure as a part of job though the condition is true. Running it manually is always working with the condition what it suppose to take. I had to free up the procedure cache everytime to make it run through job. Please help me on this.