Scheduling Pipeline using Cron

Question

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 accomplished using Cron

------------------------------
Paul Peterson
------------------------------

markshnier__you · Answer

It is not possible to trigger a subscription from a pipeline. But you could trigger a notification for some kind of dummy record that has an embedded report on it.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

paulpeterson1 · Answer

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
------------------------------

jeffpeterson1 · Answer

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
------------------------------

paulpeterson1 · Answer

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.&nbsp; Also, I need to send a report not data about a single record.------------------------------Paul Peterson------------------------------

jeffpeterson1 · Answer

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:&nbsp; https://crontab.guru/#5_1/3_*_*_*You can see on that one that it would trigger "At&nbsp;minute 5&nbsp;past every 3rd hour from 1 through 23."Or:&nbsp; 0 8,11,14 * * 1-5&nbsp; &nbsp;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,&nbsp; I'm not entirely sure how you might achieve that.&nbsp; &nbsp;I suppose you could have a dummy record that holds an embedded report,&nbsp; then it sends that record when the notification triggers.&nbsp; That way you would be able to automate sending the report each time it triggers.

------------------------------Jeff Peterson------------------------------

Forum Discussion

Scheduling Pipeline using Cron