SQL Jobs

dubbs112

I am pretty new to the SQL world. I have a decent comfort level writing small select statments to look at data in different tables. I have very little experience writing stored procedures and creating jobs though. I have a job that is running a stored procedure on a daily basis that collects info and creates an ouput file for the entire previous day. What I would like to do is have this job run many times per day but only collect any new data in the table since the previous the job ran.

Is this something that can be worked through the job in sql2005 or would it be 100% dependant on the stored procedure programming? Pretty lost here.....


THanks