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