topic Re: Monitoring capabilities for MSSQL SSIS and Oracle Enterprise Scheduler (ESS) Jobs in Open Q&A

Monitoring capabilities for MSSQL SSIS and Oracle Enterprise Scheduler (ESS) Jobs

rswarnka — Wed, 11 Dec 2019 12:28:56 GMT

We have enterprise wide applications which use MS SQL SSIS packages and Oracle Enterprise Scheduler (ESS) Jobs (Weblogic 12C). I am very much interested to know feasibility for monitoring the jobs of such technologies.

Re: Monitoring capabilities for MSSQL SSIS and Oracle Enterprise Scheduler (ESS) Jobs

dglugla — Thu, 12 Dec 2019 15:23:52 GMT

Hi @Rajesh S.

In terms of SQL jobs, you'd have to configure Oracle DB endpoint for the DBs that process such requests. Currently only Oracle DB is supported by Database Insights feature (early adopter release). MS SQL Server internal monitoring is currently planned for second half of 2020.

Database Insights is able to monitor the whole activity on the DB, so queries executed within those jobs will also be monitored.

Re: Monitoring capabilities for MSSQL SSIS and Oracle Enterprise Scheduler (ESS) Jobs

rswarnka — Fri, 13 Dec 2019 05:30:38 GMT

Hi Dariusz,

That's a good one!

I will keep looking for support for the MS SQL database there are as many as 100+ DB servers that need SSIS monitoring. The use case is alerting the team on long running or stuck job.

Re: Monitoring capabilities for MSSQL SSIS and Oracle Enterprise Scheduler (ESS) Jobs

tarjei_utnes — Tue, 28 Jan 2020 09:34:11 GMT

We have the same requiements here.

There are multiple batch jobs where monitoring the jobs is important.

Should and could be quite an easy thing to create.

Otherwise we will make a plugin that does it.

Re: Monitoring capabilities for MSSQL SSIS and Oracle Enterprise Scheduler (ESS) Jobs

Cbeecher — Wed, 07 Jun 2023 15:20:10 GMT

Did anyone come up with whether this is possible?