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.
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.