I checked the history. It runs around 5 mins. Not enough time. And the data that's updated in the tables hasn't all be updated either. It updates properly when the stored procedure is run from the query analyzer.

Thanks. CB