| 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 logHema Sunder |
 |
|
|
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? |
|
|
|
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. |
|
|
|
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 detailsHema Sunder |
|
|
|
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? |
|
|
|
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 logHema Sunder |
|
|
|
Starlet_GT
Yak Posting Veteran
81 Posts |
Posted - 2014-05-29 : 07:33:53
|
| It's the same for both 2008 & 2012. |
|
|
|
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 |
|
|
|
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 wrongNow ... how to enable this feature in SQL Server 2012, that's what I want to know. |
|
|
|
|
SQL 2012 Agent Job Error