Tools for Vertica developer to monitor his jobs.

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. 



  • Options
    Prasanta_PalPrasanta_Pal - Select Field - Employee
    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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file