November 22, 2009 at 9:52 am
I've got a long running job that has started failing. I've run it manually, which fails, and run the T-sql which is successful?? The logs appear to get backed up if you look at the folders yet it keeps showing as failed. I'm having trouble finding much of anything to go on? i miss the logging of sql 2000 compared to this which is incomplete! any way to determine what's really happening?
Message
Executed as user: PRODDB06\Administrator. ....3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:45:28 AM Progress: 2009-11-22 09:45:29.01 Source: {40CAC82A-E500-4D2A-9AA2-CAA70F8520A2} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2009-11-22 09:45:29.34 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'\\10.2.16.19".: 100% complete End Progress Progress: 2009-11-22 09:45:29.34 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'\\10.2.16.19".: 100% complete End Progress Progress: 2009-11-22 09:45:29.35 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'\\10.2.16.19".: 100% complete End Progress Progress: 2009-11-22 09:45:29.35 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_cr... The package execution fa... The step failed.
November 29, 2009 at 2:50 pm
Please, enable the step job loggin to get the complete error output and paste the output here to figure out the problem.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply