March 10, 2008 at 2:38 pm
hi ,
use msdb
select * from dbo.sysjobhistory
i know this query to see detail of all jobs but i want to see when job is started 'job time ' job started time and 'frequency type'
thaxx in advance
regards
jagpal singh
March 10, 2008 at 2:53 pm
I'm not sure exactly what you're asking. By 'job time' do you mean the time a job started executing? By 'frequency type' do you mean the job schedule?
Greg
March 10, 2008 at 3:02 pm
hi,
really thanxx for reply u r right i want to know abt which time a job started executing 'start time'
and frequency type as well
thaxxx
regards
jagpal singh
March 11, 2008 at 5:37 am
hello
greg hru
will u plz solve my problem actually i want to see at what time which job is running so ,basically i need to see that time when job is start working .
jagpal singh
March 11, 2008 at 9:12 am
The run_date and run_time columns in sysjobhistory show when the job started. Look at sysjobschedules and sysschedules for schedule data. You might also want to look at sysjobactivity.
Greg
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply