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 |
|
Big_tim
Starting Member
22 Posts |
 Posted - 2010-07-26 : 11:53:07
|
| Afternoon fellow knowledgeable SQL-ers!!I have a question about sql 2005 Job history content that hopefully you can help me out with.I need to increase the history content of a job that runs 4 times a day automatically and also a few times when started manually. Currently due to the number of steps in the job it only keeps a history of the last 10 runs. Ideally I'd like to knock this up so that I have around a week’s history. However, I'd like to increase this without doing a blanket setting in the History tab in the properties of the SQL Agent, because there are a lot of other jobs that run and I don't want to fill the MSDB db. Does anyone know if this can be done on an individual job? |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-26 : 13:06:55
|
| no. this setting is on SQL Agent only and it will affect the all the jobs. you can set under properties of SQL Agent on your local SQL Server the history settings (Maximum job history (in rows) or Maximum job history rows per job) but it will affect all the jobs.what you can do, if you want to limit yourself to only one job, is to store job history (for this particular job) in a SQL table (on your msdb database or any other database - it does not matter) and you will have history for as long as you will want.you can also create exports using Report Server and set subscription to retrieve on daily basis your job history in e.g. excel file. |
 |
|
|
|
|
|
SQL Job Agent (2005)