Hi,
when I try to run a package as Job I receive the following error
Executed as user: SITA\sqlserveragent_svc. The package execution failed. The step failed.
Has someone an idea how I can get more detailed information about WHY the job failed Tha package was created in BIDS and imported into MSDB. Running the package from the Integration Services context menu works, but starting it as a job from SQL Server Agent fails. Any idea or hint what the reason could be or how I can get more information
Thanks in advance
Nobsay
sql server agent job execution of a package failed
Sune Henriksen
Ok, as I am a newbie I wonder how the command line should look like, e.g. is it "dtexec /SQL ... " or is it sufficient to start with "/SQL .." in the command part of the job step definition
Which parameter are needed Does someone know any good help page where I can find the details
Regards
Nobsay
megs_lefevre
Errr...have you tried BOL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlcmpt9/html/89edab2d-fb38-4e86-a61e-38621a214154.htm
-Jamie
Marko Mihovilic
Jamie,
thanks for being patient with a newbie. I will read the documentation and try to get it running. I will keep you informed!
Thanks again
Nobsay
Rajat Solanky
Are you using the SSIS Job subsystem to run the package You shouldn't - as explained here: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html
-Jamie
Anwar Hossain(shovon)
Thanks for the link, I could get the package running!
Regards
Nobsay