Scheduling Job in SSIS
Yeah it says," Job failed.The job was invoked by schedule 14(Q)" That is the summary information for the job run. I assume your job has one or more jobsteps (otherwise it wouldn't actually do anything). Expand the job in the history and look at the individual steps. Did a step generate an error?MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...
February 15th, 2012 9:15am

I am using sql agent to schedule job in SSIS. But every time the job fails to run from SQL agent, giving the error as: "The job was invoked by schedule 14(Q)" Do anybody have some clue about this error. Thanks
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2012 5:02pm

That doesn't appear to be an error, does it? Can you open the Job Activity Monitor, right-click on the job, select "View history", expand the top node, and look at the complete information? Possibly post some of it? Thx. Talk to me now on
February 18th, 2012 6:23pm

Yeah it says," Job failed.The job was invoked by schedule 14(Q)"
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2012 6:35pm

Hi, I would suggest you to check prmissions for that account to execute that job. Srikrishna
February 18th, 2012 7:05pm

Harry, Please check this video if you are trying to run the package with the account which is not been used to create the package. http://msdn.microsoft.com/en-us/library/dd440760(v=sql.100).aspx Regards, Eshwar.
Free Windows Admin Tool Kit Click here and download it now
February 19th, 2012 1:16am

Yeah it says," Job failed.The job was invoked by schedule 14(Q)" That is the summary information for the job run. I assume your job has one or more jobsteps (otherwise it wouldn't actually do anything). Expand the job in the history and look at the individual steps. Did a step generate an error?MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...
February 19th, 2012 1:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics