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.
Tools for Vertica developer to monitor his jobs.
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.
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.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
