What report can I run show deconfigured SQL agents from the java console ?
Solved
deconfigured SQL agent report
- Novice
Best answer by christopherlecky
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
+16- Explorer
- Answer
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.