Compiler Error after upgrade

Hi, 

We have just upgraded from 8.1.1 to 8.1.4. All this are OK w.r.t web portal, application server, tools etc. but when I try to compile the database after committing a change, its giving me following error:

"Error during execution of statement: select top 1 1 --h.run_date,h.run_time, h.run_status, from msdb..sysjobs j join msdb..sysjobhistory h on j.job_id=h.job_id where j.name = dbo.qbm_FGIServerAgentJobName('QBM_PwatchDog')

and j.enabled=1 and h.run_Status=1 --succeededand dateadd(..."

Any idea on how to sort this one out?

Parents Reply Children