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