Job Failed

  • Can anyone help me with following error?

    The job failed. The Job was invoked by Schedule 307 (nightly refresh). The last step to run was step 1 (Run SSIS package from snlsqldev > package store > File System).

  • You will need to provide the error on Step level, and not only package level.

    Go into the SQL Agent, under jobs, drop down the specific job, focus on the step that failed and read the error description, then post.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • I just ran the job at a step and working fine now.

    Thanks for your help

  • You should still determine the cause to prevent further failure.

Viewing 4 posts - 1 through 3 (of 3 total)

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