SQL Server Agent Performance Issue

• yogi123

  SSCrazy

  Points: 2932

  More actions

  October 7, 2013 at 9:38 am

  #278711

  Hello Everyone

  I am facing one issue with SQL Server Agent.

  I schedule on job,There is one T-SQL in it. If i execute that T-SQL in SSMS it takes only 12 minutes to run but same T-SQL Script I schedule from SQL Server Agent and it takes 6 Hours to Finish. I refresh SQL Server Agent once and re-ran Job but still it takes same time.

  If anybody knows this issue please help me to resolve.

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  October 7, 2013 at 1:37 pm

  #1656507

  Are you running it durng high traffice hours? During production? What type of script is it?

  MCSE SQL Server 2012\2014\2016