What report can I run show deconfigured SQL agents from the java console ?

What report can I run show deconfigured SQL agents from the java console ?
You may have to roll your own using a dataset.
The query would look something like so.
use commserv
SELECT [cl].[ClientName] as 'clientName',
[cl].Id as 'clientId'
FROM [dbo].[CNClientInfoView] as cl WITH(NOLOCK)
INNER JOIN [dbo].[CNIDAInfoView]as iDa WITH(NOLOCK)
ON [cl].[id] = [iDa].[ClientID]
Where [iDa].[AppTypeID] = 81 AND [iDa].[Status] = 2
ORDER by clientName;
Reference this post by
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.