SQL SERVER AGENT failed when running SSIS PACKAGE
-
Hi everyone...
I m trying to run ssis package from SQL SERVER AGENT, and it give this error:
Message
The job failed. The Job was invoked by User sa. The last step to run was step 1 (SSISPAckegeNAme).
Please help me resolving this error.
-
You need to look at the step details for that job to get the specific error caused the step to fail. You could also use a query like this:
USE msdb ;Go
SELECT
name,
enabled,
description,
start_step_id,
date_created,
date_modified,
version_number,
step_id,
step_name,
sql_message_id,
sql_severity,
message,
run_status,
run_date,
run_time
FROM
dbo.sysjobs AS J JOIN
dbo.sysjobhistory AS S
ON S.job_id = S.job_id
WHERE
S.run_status = 0 AND
S.step_id > 0
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Hi Jack Corbett...thank you for your replay..
this is result from query :
Executed as user: Domain\Administrator. The package execution failed. The step failed.
Why its also get error like this, although i created new CREDENTIAL and Proxy for SSIS Package Execution and use this proxy instead of sql server agent account. As contained in the forum http://www.sqlservercentral.com/Forums/Topic543713-148-1.aspx.
Any solution please....
Thanks,
-
phina_el (1/24/2010)
Hi everyone...I m trying to run ssis package from SQL SERVER AGENT, and it give this error:
Message
The job failed. The Job was invoked by User sa. The last step to run was step 1 (SSISPAckegeNAme).
Please help me resolving this error.
This is not enough. When you open the Job history execution log, expand the failed step and select the sub-children. There should be more details for this error.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply