Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL JOB takes too much time to execute Expand / Collapse
Author
Message
Posted Wednesday, January 8, 2014 11:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 3, 2014 10:46 AM
Points: 21, Visits: 61
Hi,
I created one job, when execute it it takes around 9 hours and when i manually executes that sp which is used in job than only takes 1 min.

So why this happens ?

Please reply. it will be helpful,

Thanks in advanced.
Post #1529211
Posted Thursday, January 9, 2014 5:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 12:52 PM
Points: 111, Visits: 343
read something about parameter sniffing.
put your code if its possible
Post #1529291
Posted Thursday, January 9, 2014 6:29 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:40 AM
Points: 2,480, Visits: 3,023
Is this problem reproducable? Does it occur when the job is scheduled to run at a different moment? Are other processes running at the same moment (could cause blocking issues)?


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1529313
Posted Thursday, January 9, 2014 10:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 11, 2014 9:41 AM
Points: 1,159, Visits: 6,478
What time does the job run and what time are you testing your code?

Is anything else running when the job runs (scheduled)?
Post #1529444
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse