October 22, 2009 at 7:57 am
1. EXECUTION ?
I have a Maintenance Plan under SS2005 with 3 Sub-Plans:
1) Full DB Backup -> Calls T-SQL script for Backup operations
2) Differential Backup -> Ditto to 1)
3) Transaction Log Backup -> Ditto
I noticed 3 new SQL Server Agent jobs after I had setup the Sub-Plans under MP in SSMS.
<MAINTPLAN_NAME>.<SUBPLAN_NAME_1>
<MAINTPLAN_NAME>.<SUBPLAN_NAME_2>
<MAINTPLAN_NAME>.<SUBPLAN_NAME_3>
I scheduled and enabled the three jobs, checking both in MP and Agent jobs wizards to make sure that schedules were as set and that they were enabled.
Will they now fire automatically at the scheduled time, or is there an additional step. (I noticed there is a 'Start Job at Step....) function for each Job in the SQL Server Agent list in SSMS - do I need to do this also?
2. Post-Mortem Log analysis ?
Which logs do I look at for the post-execution of the Maint. Plan Sub-Plan agent jobs? I would assume that the 'SQL Server Logs' choice under Management folder in SSMS Object Explorer would give me at least summary info - if not details of execution/errors, etc. ??!!
3. Might want to setup notification, right?
For now I'm just doing backup ops, but will be doing Update Statistic, DB Integrity checks and Index re-org, re-builds as well.
Thanks from a real newbie, accidental DBA
Zee (Atlanta, GA) 😉
October 22, 2009 at 10:23 am
For
1). Since the plan had full, differential and TLog backup steps SSMS will create 3 jobs each for one of its kind. You cna change schedule or manage scheduling by right click on job property.
2). You can check in sql server log and also by right click job and select view history tab to see how and when job got executed.
3). Might want to setup notification, right? For this you can set up database mail. follow this link on how to create profile on database mail.
http://www.kodyaz.com/articles/sql2005-database-mail.aspx
SQL DBA.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply