Scheduling Pipeline using Cron
Is it possible to use the Cron feature in the pipeline scheduling to send a report several times per day. For example, suppose I want to sent a report out M-F at 9:00, 1:00 and 5:00, can that be acco...
Forum Discussion
I know I can't trigger the subscription, but recall seeing a post about using a pipeline to send a report. Is it in fact possible to email a report using a pipeline? And can the cron settings be used to send the report multiple times per day? If not, it's not a huge issue, I can create a pipeline for each time.
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------
You can use CRON to schedule a pipeline to check/uncheck a box and then the act of checking/unchecking the box can be used to trigger a notification.
------------------------------
Jeff Peterson
------------------------------
------------------------------
Jeff Peterson
------------------------------
Jeff,
Is it possible to use cron for multiple times per day or will I need a separate pipeline for each time I need the data sent. Also, I need to send a report not data about a single record.
------------------------------
Paul Peterson
------------------------------Yes, you can set up the CRON code to trigger any number of times per day.
Here's an example and a useful site for creating the CRON code: https://crontab.guru/#5_1/3_*_*_*
You can see on that one that it would trigger "At minute 5 past every 3rd hour from 1 through 23."
Or: 0 8,11,14 * * 1-5 which would run “At minute 0 past hour 8, 11, and 14 on every day-of-week from Monday through Friday.”
You can play with the formatter there, then put the code into your pipeline.
As for the sending of a report, I'm not entirely sure how you might achieve that. I suppose you could have a dummy record that holds an embedded report, then it sends that record when the notification triggers. That way you would be able to automate sending the report each time it triggers.
------------------------------
Jeff Peterson
------------------------------