You are the database administrator of your company. The network contains an instance of SQL Server 2008.
You create several jobs on the SQL server. After several days, the SQL Server Agent service stops. You want toview the jobs that were being executed when the service stopped.
Which system table should you check?
A.
sysjobstepslogs
B.
sysjobhistory
C.
sysjobs
D.
sysjobactivity
Explanation:
You should check the sysjobactivity system table. The sysjobactivity system table is a SQL Server Agent tablein the msdb database that records information about the current SQL Server Agent job activity and status. Whenyou start the SQL Server Agent service, a new session is created, and all the existing defined jobs are recorded inthe sysjobactivity system table. If the SQL Server Agent service stops unexpectedly, you can check the sysjobactivity system table to identify jobs that were being executed when the service stopped. You should not check the sysjobstepslogs system table because this table does not contain information aboutcurrent job activity and status. The sysjobstepslogs system table contains information about job step logs. You should not check the sysjobhistory system table because this table does not contain information about current job activity and status. The sysjobhistory system table contains information about the execution of SQLServer Agent scheduled jobs. You should not check the sysjobs system table because this table does not contain information about current jobactivity and status. The sysjobs system table records the information for each SQL Server Agent scheduled jobthat is to be executed.
Objective:
Maintaining SQL Server InstancesSub-Objective:
Manage SQL Server Agent jobs.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration >Administration: How-to Topics > Automated Administration How-to Topics (SQL Server Management Studio) >How to: View Job Activity (SQL Server Management Studio) MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > Transact-SQLReference > System Tables (Transact-SQL) > SQL Server Agent Tables (Transact-SQL)