Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

shedule job

How to shedule job in every 2 hour??

6 Community Answers

Matillion Agent  

Ian Funnell —

Hi Ganesh,

You would choose a comma-separated list of hours in the Hour tab, e.g.

0,2,4,6,8,10,12,14,16,18,20,22

Best regards,
Ian


Ganesh Pitchai —

Hi lan,

timezone:PST, hours:0,2,4,6,8,10,12,14,16,18,20,22 ,minutes:0...

i tried but test shedule shows

"The scheduled time overlaps your Redshift Maintenance Window (tue:09:30-tue:10:00)"???

Thanks
Ganesh


Matillion Agent  

Laura Malins —

Hi Ganesh

This is a check Matillion runs to ensure doesn’t run during your Redshift Maintenance window, because if Redshift is down Matillion will not run the jobs successfully.

The message you see is just a warning. The scheduled jobs are still going to run if Redshift isn’t in Maintenance mode.

You can change the Maintenance window of Redshift if you want, but I’d recommend changing the timing of the job(s) which overlap with the window.

Thanks
Laura


Ganesh Pitchai —

hi laura,

you are right!!!

it is just a downtime problem...job is running sheduled time perfectly...

Thanks
Ganesh


Joshua Vogel —

As a follow up, if I am running a job every 15 minutes all day, its a lot easier to put in:

Hours of the Day: *
Minutes: 0,15,30,45... will the job just not run during the maintenance window? or should I specify a different schedule during that period?


Matillion Agent  

Paul Johnson —

Hi Joshua,

The job will retry at the next scheduled time if it fails to execute due to Redshift being down.

Post Your Community Answer

To add an answer please login