No it isn't static.

I made this change and it is working again.

In Reporting Services, user-defined subscriptions that are created according to the permissions granted by the Manage individual...

It was a stored proc

Found it. Thanks

I guess i'm a bit confused. I don't have any jobs, I have lots of jobs that have this but they are all replication

I have checked all the jobs in the agent and I don't see one sending emails for server reboot.

That worked. Thanks

I'm trying not to click on every server. I am looking for a query where I can open ssms and run a query that will look at all servers...

yeah it was designed poorly just trying to help them get some reporting from it by the max number.

Not sure how I would add it to the derived subquery

I have one more question to this code you helped me with. I also want the createdon displayed but when I added it after select I get and error:

Msg...

If I change the word insert to update it works

Thanks, this helps

99 and it will always be a integer

They want to ignore these NULLS, blank values in that column. so if the word null is typed in or blank, they don't want to see them

I don't think they want to see any NULL values.