title: How to execute scheduled SQL script on Amazon Redshift?
body: <p>I have series of ~10 queries to be executed every hour automatically in Redshift (maybe report success/failure).</p>
  
  <p>Most queries are aggregation on my tables.</p>
  
  <p>I have tried using AWS Lambda with <a href="http://docs.aws.amazon.com/AmazonCloudWatch/latest/events/ScheduledEvents.html" rel="noreferrer">CloudWatch Events</a>, but Lambda functions only survive for 5 minutes max and my queries can take up to 25 minutes.</p>