Schedule analyze statistics

I want to schedule to analyze my statistics on a daily bases...

Is there some sort of scheduler in Vertica 7.1 or will I have to use cron jobs?

I'm not against using cronjobs, just don't want to hard code the password (company doesn't approve)

But if cron is the only way to go, what would be your recommedation on this?

There are no schedules in Vertica.

I agree that having password in cron job is not secure.

Look at other tools with better security

We run analyze statistics as azkaban job and azkaban running in Docker container.
You still need password for a job, but it is not easily accessible.

Sign up