June 17, 2009 at 2:53 pm
Hi All
Hey Iam new to this world(sql server).i want to see my self as a sql dba in the furture.soo plz help me.I am sorry to ask such kind off questions
1.How to check backups,jobs in msdb
2.How to and where to check these backups and jobs are failed and how to trouble shoot these.
plzz tell me is there any navigation for to check this or do we have any (DBCC or SP) to check
June 17, 2009 at 3:10 pm
There are system tables in msdb that you can query (sysjobhistory, sysjobs) and stored procedures (sp_help_jobhistory), but it's far easier to use the SQL Server Management Studio GUI to look at jobs and their history.
You should see a SQL Server Agent icon in the Object Explorer window of SSMS. Expand it and select Job Activity Monitor to see the list of jobs and their current status. You can right-click on a job to see it's properties and history.
Oh, and all this is documented in BooksOnLine that came with your SQL Server software.
Greg
June 17, 2009 at 3:21 pm
IF you are using something like a maintenance plan, and that's a good idea as you get started, be sure you enable logging. When something fails, check the log file, not the Agent history in msdb. There are more details in the log files.
June 17, 2009 at 3:30 pm
Hi thanks for the reply.
u meen to check error logs in sql agents. or log file is different
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply