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 |
|
cin
Starting Member
2 Posts |
 Posted - 2005-07-25 : 11:10:21
|
| Hello,I'm new to this forum, and not really an expert in SQL server administration, so it might be that my question sound a bit stupid...I'm monitoring a certain number of jobs (on a single SQL server)for a collegue of mine (on holidays) and I realize that the job history is available only on some jobs but not on others...I couldn't find any option to tick where you define that a job has or has no history...any suggestions ?thanks ! |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-25 : 11:20:13
|
| When you compile a Maintenance Plan you can decide if you want to write history on the msdb.dbo.sysdbmaintplan_history table on the local/remote server or not.You can query these tables on the msdb system database:sysdbmaintplanssysdbmaintplan_databasessysdbmaintplan_historysysdbmaintplan_jobsOf course you can go via Enterprise Manager and under Management you can see all the jobs you have.Also under Management you have "Database Maintenance Plan", you can just edit one of these and see the options under "reporting".Franco |
 |
|
|
cin
Starting Member
2 Posts |
Posted - 2005-07-26 : 03:26:38
|
| perhaps I didn't explain clearly enough, or else I didn't fully understand the reply... but I meant the JOB history of every single job.I did indeed find the option for the maintance plan with your indications, and it is checked.But for the jobs I can't find such an option (or do I mix things up ?) |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-26 : 03:33:47
|
| Check if you have Maintenance Plan on your box.If yes, then you can edit the plan and go under "reporting" to see the properties of each job.Franco |
|
|
|
|
|
|
job history // some jobs have some jobs haven't ??