SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 SQL 2012 Agent Job Error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starlet_GT
Yak Posting Veteran

Pakistan
81 Posts

Posted - 05/25/2014 :  23:55:02  Show Profile  Reply with Quote
Hi,

In SQL Server 2012 under SQL Server Agent we have job activity monitor.

If a job fails, we go to the job history and expend the job to check the error. But unfortunatlly I am unable to see the complete error details.

It only says ... job failed, but did not give complete error details.

Please tell me how to enable complete error details in SQL Server Agent Job Activity Monitor.

Thanks in advance.

sunder.bugatha
Starting Member

India
21 Posts

Posted - 05/26/2014 :  06:25:04  Show Profile  Click to see sunder.bugatha's MSN Messenger address  Send sunder.bugatha a Yahoo! Message  Reply with Quote
Configure the SQL job to write the details in an output log

Hema Sunder
Go to Top of Page

Starlet_GT
Yak Posting Veteran

Pakistan
81 Posts

Posted - 05/26/2014 :  06:35:39  Show Profile  Reply with Quote
How we can configure a job to write logs, and does this resolve the issue?
Go to Top of Page

Starlet_GT
Yak Posting Veteran

Pakistan
81 Posts

Posted - 05/27/2014 :  03:20:32  Show Profile  Reply with Quote
I have configured job to write log but it is writing in dbo.sysssislog or in a text file depends upon option you select. Here I want complete error details in "Job Activity Monitor" when I expend a failed job.

Go to Top of Page

sunder.bugatha
Starting Member

India
21 Posts

Posted - 05/27/2014 :  05:34:51  Show Profile  Click to see sunder.bugatha's MSN Messenger address  Send sunder.bugatha a Yahoo! Message  Reply with Quote
It depends on the type of task you are performing in the job. If it is an SSIS package then you can probably configure an output (text) file and it will write all the details into it. Also the message column in sysjobhistory table has max length of 8000 hence it might not write all the error details

Hema Sunder
Go to Top of Page

Starlet_GT
Yak Posting Veteran

Pakistan
81 Posts

Posted - 05/27/2014 :  06:34:26  Show Profile  Reply with Quote
Sunder, thanks for your reply. I tried to put things in text output file from SSIS package but it return exception error only, no detail is avaliable in the error log, whereas in SQL 2008 it return whole error in "Job Activity monitor" which is quite handy for me.

Is there any way to get error details in failed jobs step details?
Go to Top of Page

sunder.bugatha
Starting Member

India
21 Posts

Posted - 05/29/2014 :  07:19:45  Show Profile  Click to see sunder.bugatha's MSN Messenger address  Send sunder.bugatha a Yahoo! Message  Reply with Quote
Can you compare below settings in SQL 2008 and 2012?

Right click on SQL Agent -> Properties -> Hisotry -> Limit size of job history log.

Limit size of job history log :
Sets limits for the amount of job history information that SQL Server Agent retains in the log

Hema Sunder
Go to Top of Page

Starlet_GT
Yak Posting Veteran

Pakistan
81 Posts

Posted - 05/29/2014 :  07:33:53  Show Profile  Reply with Quote
It's the same for both 2008 & 2012.
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1642 Posts

Posted - 05/30/2014 :  19:21:05  Show Profile  Reply with Quote
Have you looked in:
- The Job Step history; not just the Job history (Just asking to remove the obvious)
- SQL Server Logs
- SQL Server Agent Error Logs



Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy
Go to Top of Page

Starlet_GT
Yak Posting Veteran

Pakistan
81 Posts

Posted - 06/02/2014 :  02:16:30  Show Profile  Reply with Quote
In 2008 we can view error in job history but in 2012 it just says "job failed" no further information is avaliable there ...

What I want it to show me the complete error so that I can figure out what's wrong

Now ... how to enable this feature in SQL Server 2012, that's what I want to know.

Edited by - Starlet_GT on 06/02/2014 02:17:40
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000