Job failed. The job was invoked by schedule

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Developer779
    New Member
    • Feb 2019
    • 1

    Job failed. The job was invoked by schedule

    I have an SSIS package that contains a simple SQL execute the task which contains a simple query :

    Update table
    set column_name = xyz
    where column = 1

    I have created a catalog in Management Studio and have deployed the SSIS package in the catalog folder. I started the SQL Server Agent and created a job to schedule the package to execute, but it fails and gives an error. 'The job failed. The job was invoked by schedule 11'. I don't know What is causing the problem
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Could literally be anything. You need to drill down to the log for the step that failed, that will tell you in more detail why it failed. The message you posted is just the log at the very highest level.

    Comment

    Working...