Tools for Vertica developer to monitor his jobs.

Mark_2

Hi ,
Is there any tools for Vertica developer to monitor his Vsql jobs, like the informtica work-flow monitor, it can give you a eye on the process of the ETL jobs. 

Thanks.

Prasanta_Pal

What kind of monitoring you are looking for a database? The jobs in vertica meaning, either query or load or delete the data in database. If you want to monitor the details about those, there are certain system tables. 
One example could be: select * from sessions; will give some many sessions are currently running.
select * from query_requests; will give you what queries are ran or running...

if you specify a bit more detail about your requirement that would be great.