| How to
list job execution history? |
|
Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor, SQLCMD or other client software
to get a list of job execution history
by jobs and steps:
use AdventureWorks;
select JobName = name,
StepName=Step_name,
RunDate = run_date,
DurationInMinutes=(run_duration/100)+1
from msdb.dbo.sysjobhistory jh
join msdb.dbo.sysjobs j
on jh.job_id = j.job_id
order by run_date,jh.job_id, step_id
|
| |
| SQLUSA.com
Home Page |
|
|
SQL Server Training at www.sqlusa.com.
SQL Server 2008 Video Training at www.sqlusa.com.
SQL Server 2005 Training Videos at www.sqlusa.com.
Microsoft SQL Server 2000 Training Videos at www.sqlusa.com.
|
FREE SQL & Business Intelligence / OLAP Short Videos on YOUTUBE.com |
|
Search SQLUSA FREE SQL Server Articles & FREE T-SQL Scripts |
Copyright 2005-2011, SMI Corp. All Rights Reserved.
SQL Server 2012 is a program product of Microsoft Corporation. SQL Server 2008 is a program product of Microsoft Corporation. SQL Server 2005 is a program product of Microsoft Corporation. SQL Server 2000 is a program product of Microsoft Corporation. |
|