Tools for Vertica developer to monitor his jobs.

Mark_2Mark_2
in General Discussion
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.

Comments

  • 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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...