SQL Agent jobs fails - SP_FORCE_SHRINK_ALL_LOGS

• Rosa Brower-260614

  SSC Journeyman

  Points: 82

  More actions

  December 27, 2005 at 1:40 pm

  #90271

  I have implemented the stored procedures sp_force_shrink_log and SP_FORCE_SHRINK_ALL_LOGS to shrink the logs for all databases once a week. The SQL Agent job fails every time altough I do not see any errors or messages in the output. Any ideas?

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  December 28, 2005 at 12:45 am

  #611653

  Add SELECT or PRINT output to your stored procedures, use RETURN (1) and RETURN (0) so the SQL Server Agent Job can receive proper return values.

  Have you tried using the "show step details" check box when viewing the Job History?

  Andy