Hi,

Thanxxx its so nice query .its working perfect .but will u plz tell me where is

FROM MSDB..SysJobHistory

i cant find this sys.jobhistory

regards

jagpal singh