By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,315 Members | 1,281 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,315 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
Feb 5 '19 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,441
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.
Feb 5 '19 #2

Post your reply

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