472,131 Members | 1,451 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,131 software developers and data experts.

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 1278

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.