November 28, 2008 at 7:46 am
i got email this morning that one of the jobs failed. I went to that instance and looked at the job history..this is error which i found.
Date
LogJob History (Test Backups.Subplan1)
Step ID0
ServerSQLTest\Test
Job NameTest Backups.Subplan1
Step Name(Job outcome)
Duration00:35:14
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
The job failed. The Job was invoked by Schedule 3 (Test Backups). The last step to run was step 1 (Subplan1).
And then the other error found just below the first one is:
LogJob History (Test Backups.Subplan1)
Step ID1
ServerSQLTest\Test
Job NameTest Backups.Subplan1
Step NameSubplan1
Duration00:34:56
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: Usera . ... Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: Source: Maintenance Cleanup Task Executing query "EXECUTE master.dbo.xp_delete_file 0,N'J:\Backups',".: 100% complete End Progress Progress: Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create.hary N'J:\Backups\m".: 4% complete End Progress Progress: Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create.hary N'J:\Backups\m".: 8% complete End Progress Progress: 2008-11-26 21:00:23.84 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_cre... The package execution fa... The step failed.
is the ssis package failed?..please suggest me what should i do now?
November 28, 2008 at 11:22 am
What's to wonder? They didn't post because they did not know the answer.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply