July 15, 2011 at 7:50 am
Hi,
In our dev server, I have created a maintenance plan for backup specific databases.
I did’t see any thing in job view history (job fail or success). I could see maintenance plan history.
Do I need to enable something to view job history?
Dev – SQL Server 2005
9.00.4060 version.
Thanks for you help.
July 15, 2011 at 7:57 am
How do you run your maintenance plan? You will only see anything in the job history if you run the job that was created with the maintenance plan, not if you run the maintenance plan in any other way.
Can you see history for any other jobs?
John
July 15, 2011 at 8:07 am
Hi John, Thanks for your reply.
Created a scheduled plan in maintenance plan itself. So automatically job is created and running as per schedule.
This is only maintenance plan I created in this server for backups.
SQL job is running fine and but I could not see anything in the job history. Not sure why?
July 15, 2011 at 8:10 am
In the Job Properties ->Steps, Edit the step and go to advanced. You will find include step output in history, check that option.
July 15, 2011 at 8:12 am
How often does the job run? What happens if you create a job to execute a trivial T-SQL statement and run that - can you see the history for it?
John
July 15, 2011 at 8:35 am
ssismaddy (7/15/2011)
In the Job Properties ->Steps, Edit the step and go to advanced. You will find include step output in history, check that option.
Perfect. Now I see the Job view history details.
Thanks Maddy!
Thanks John!
What are the other regular maintenance tasks you guys recommend? Thanks!
July 15, 2011 at 8:39 am
laddu4700 (7/15/2011)
What are the other regular maintenance tasks you guys recommend? Thanks!
DBCC CHECKDB and REBUILD INDEX. For the latter, you may prefer to use scripts instead of a maintenance plan - you get more control that way. There are lots of scripts on this site and elsewhere to get you started.
John
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply