I want to know where to see SQL Server start/stop logs for each instances and SQL Server agent/job start/stop logs? I am developing some tools to monitor SQL Server status. I am using SQL Server 2008 Enterprise.
thanks in advance, George
|
I want to know where to see SQL Server start/stop logs for each instances and SQL Server agent/job start/stop logs? I am developing some tools to monitor SQL Server status. I am using SQL Server 2008 Enterprise. thanks in advance, George
| |||
|
feedback
|
|
You will find all of the SQL Server activities in the Application Event Log. You can find this by going to Control Panel > Administrative Tools > Event Viewer > Application, and looking for "MSSQLSERVER", or "MSSQL$INSTANCENAME" in the "Source" | |||
|
feedback
|