Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 SQL 2012 Agent Job Error

Author  Topic 

Starlet_GT
Yak Posting Veteran

81 Posts

Posted - 2014-05-25 : 23:55:02
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
Yak Posting Veteran

66 Posts

Posted - 2014-05-26 : 06:25:04
Configure the SQL job to write the details in an output log

Hema Sunder
Go to Top of Page

Starlet_GT
Yak Posting Veteran

81 Posts

Posted - 2014-05-26 : 06:35:39
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

81 Posts

Posted - 2014-05-27 : 03:20:32
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
Yak Posting Veteran

66 Posts

Posted - 2014-05-27 : 05:34:51
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

81 Posts

Posted - 2014-05-27 : 06:34:26
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
Yak Posting Veteran

66 Posts

Posted - 2014-05-29 : 07:19:45
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

81 Posts

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

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2014-05-30 : 19:21:05
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

81 Posts

Posted - 2014-06-02 : 02:16:30
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.
Go to Top of Page
   

- Advertisement -