quote:

---

Originally posted by rds207

I created a Job with the Job Step having following syntax

SELECT * FROM sysjobhistory
WHERE run_duration >= '18000' and run_date > getdate() - 3


BEGIN
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'qctreport',
@recipients = 'emailaddress(mine)',
@subject=N'ALERT :: ASWReport Data is out of sync...' ;
END
GO

But i get an error as the run_date value is in format 20100321,

So how do i chaneg the syntax where the query check data for last 3 days from today ,

quote:

---

Originally posted by rds207

Hi

I have created some 15 Jobs , but some jobs seems to be hanging sometimes, could any one please assist me in creating an stored procedure for alerting me with an email , when the run duration is > 18000seconds (5 hrs)?

I wanted to create a package which queries the Data in MSDB.SYSTABLES.DBO.SYSJOBHISTORY table , and looks for the Jobs which has runduration > 18000 and send me an email ....

Please let me knwo how do i create a package and Job for this...

Any inputs are highly apreaciated...

Thank you

---

---