Post reply

Maintance Plan

  • August 18, 2010 at 1:40 pm

    #387609

    When I ran job I got this error:The package execution failed. The step failed. I get this error when I view job history

  • August 19, 2010 at 2:59 am

    #1208942

    Hi,

    When you go to job history, you can find the 3 steps under the job....

    i think u have seen top step in those 3 steps...

    if you click on middle step.. you can get the detailed error..

    try it.. hope u got the point.

    GaNeSH

  • August 19, 2010 at 3:51 am

    #1208967

    Krasavita (8/18/2010)

    When I ran job I got this error:The package execution failed. The step failed. I get this error when I view job history

    right click the maintenance plan and see "View History"

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • August 19, 2010 at 4:41 am

    #1208995

    Here is the error:

    Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed. Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed.

    Where can see syntax?

    Thank you

  • August 19, 2010 at 8:22 am

    #1209147

    Krasavita (8/19/2010)

    Here is the error:

    Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed. Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed.

    Where can see syntax?

    Thank you

    What does the task/plan/step that is failing do? ie if it is a backup task is it going to a valid location. Did it work before? Is it a SQL maint plan or is it scripted tasks?

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • August 19, 2010 at 8:41 am

    #1209166

    Can you specify what kind of job ????

  • August 19, 2010 at 11:35 pm

    #1209462

    Add an output file to the job step. That file will have more details about the job run status

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • August 20, 2010 at 7:29 am

    #1209646

    @Krasavita

    What does the job do?

    What's the code of the first step??

    Go to the job, right click, properties,steps, edit and then you can see the code...

    write here what is the code..

    Thanks,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • August 22, 2010 at 11:25 pm

    #1210233

    Specify what your job does...and what step 1 for

    Commit to Never Ending Improvement

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply