424,294 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,294 IT Pros & Developers. It's quick & easy.

Job failed. The job was invoked by schedule

P: 1
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
2 Weeks Ago #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,303
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.
2 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.