470,647 Members | 1,248 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

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
Feb 5 '19 #1
1 5098
Rabbit
12,516 Expert Mod 8TB
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.

Similar topics

1 post views Thread by Piero Cannizzaro | last post: by
1 post views Thread by Steven | last post: by
1 post views Thread by Terri | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.