use msdb
go
select * from dbo.sysjobhistory
go
select * from dbo.sysjobs
go
select * from dbo.sysjobservers
go
select * from dbo.sysjobsteps
go
sql2005日志默认在SQL安装路径C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG文件夹中。
use msdb
go
select * from dbo.sysjobhistory
go
select * from dbo.sysjobs
go
select * from dbo.sysjobservers
go
select * from dbo.sysjobsteps
go
sql2005日志默认在SQL安装路径C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG文件夹中。