The most recent content from our members.
Hey all, Ive got an app insight template that is green for eveything but Job Agent. I get the error..... No valid data was received. The SELECT permission was denied on the object 'syssessions', database 'msdb', schema 'dbo'. Invalid object name '#job_results'. Anyone get any Ideas?
I would like to alert, and report on, jobs that fail. But, only for jobs that are enabled. I have a whole listing of SQL jobs that the last time they were run they failed. So, the DBA just disabled them and doesn't want to delete them. Everytime I run a report on failed jobs they show up on the list even though the jobs…
It looks like you're new here. Sign in or register to get started.