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.
| Author |
Topic |
|
cddot
Starting Member
37 Posts |
 Posted - 2009-06-23 : 05:35:47
|
| I have a Maintenance Plan called Job123.When I view the Job History for Job123 under Maintenance Plans, I see history going back one month as expected because I have a History Cleanup Task to delete historical data older than 1 Month.But when I View History for the same job Job123 under SQL Server Agent/Jobs, I can only see history for the past day. There are no filters applied. What am I missing? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-23 : 06:51:46
|
Are you using Microsoft SQL Server 4.2, 6.0, 6.5, 7, 2000, 2005 or 2008?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
cddot
Starting Member
37 Posts |
Posted - 2009-06-23 : 08:19:43
|
| Sorry, I'm using 2005. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-23 : 08:59:38
|
How oftern is the job run?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
cddot
Starting Member
37 Posts |
Posted - 2009-06-23 : 10:13:26
|
| Every 30 minutes. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-23 : 10:19:14
|
Are you appending to the same file, or is the check mark not there?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
cddot
Starting Member
37 Posts |
Posted - 2009-06-23 : 20:53:48
|
| I'm referring to the View History of the jobs, which I thought is stored in tables rather than files. I can't see any files/check marks under Job<right-click>/Properties. Can you clarify what you mean by "appending to the same file"? |
|
|
|
cddot
Starting Member
37 Posts |
Posted - 2009-06-24 : 03:45:24
|
| I think I can explain the SQL Server Agent Job History which is determined by the values set for history log size, and this corresponds to the sysjobhistory table as well as what I can see for the View History, which is history for the past day or so.But Maintenance Plans View History goes as far back as a month. The history doesn't appear to be in the sys* tables so where are they stored? |
|
|
|
|
|
|
|
|
Agent Job History appear "truncated"