469,313 Members | 2,261 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,313 developers. It's quick & easy.

get the jobs run in a particular time interval from sysjobhistory

I have to send the jobs status that are started running from the previous day 9.00 a.m to today 9 a.m from the table sysjobhistory in sql server msdb database.But in that table , date and time are seperately present. also they are of datatype 'int'.
pls anyone tell the query extract the jobs that are running between the specified time interval
Aug 21 '08 #1
0 1210

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Marcus | last post: by
2 posts views Thread by androtech | last post: by
2 posts views Thread by Alexey Aksyonenko | last post: by
4 posts views Thread by archana | last post: by
2 posts views Thread by dwasbig9 | last post: by
15 posts views Thread by student4lifer | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.