Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Taking more time..

Author  Topic  mdara Starting Member 1 Post Posted - 2009-08-20 : 17:09:52 Hi, I have a job which is scheduled on the server that runs for every 5mins. The job just executes one of the storedprocedure which pulls the data from one table to other table. The storedprocedure uses the cursors. So my question is, when I run the storedprocedure manually its taking far lesser time than running it from Job. So why there is a time difference in running? Both should take same time more or less. But the difference is almost one hour. What could be the reason behind this? Thanks!