[mfranz@ti-prod-use1-mgmt-03 ~]$ sudo -u tradeideas crontab -l #MAILTO=kathleen@trade-ideas.com #56 13 * * * cd /var/www/Supporting_Scripts/; host api.createsend.com MAILTO=dmabe@trade-ideas.com,kathleen@trade-ideas.com,william@trade-ideas.com #syncs existing users with campaign monitor for email/segmenting purposes 59 19 * * * cd /var/www/Supporting_Scripts/campaignmonitor ; php sync_subscribers.php -c > /tmp/sync_subscribers.log MAILTO=dmabe@trade-ideas.com,kathleen@trade-ideas.com,william@trade-ideas.com #This script notifies the user via email when he needs to re-sign his exchange agreements. (and disables service if he's past the deadline) 12 3 * * * cd /var/www/Supporting_Scripts/nyse_redo_notifications/; ./nyse_redo_notifications.sh MAILTO=kathleen@trade-ideas.com #This script notifies the user via email when he needs to re-sign his exchange agreements. (and disables service if he's past the deadline) 30 3 * * * cd /var/www/Supporting_Scripts/nyse_redo_notifications/; ./nyse_redo_notifications_stripe.sh MAILTO=dmabe@trade-ideas.com,kathleen@trade-ideas.com,william@trade-ideas.com #free_preview.php - controls the test drives. Enables users for the test drive and then disables them at the end */5 * * * * cd /var/www/Supporting_Scripts/test_drive ; php free_preview.php -m1000 >> log.20220812.txt #Owner: Dave Mabe. Disable accounts where nyse expired MAILTO=dmabe@trade-ideas.com,kathleen@trade-ideas.com,william@trade-ideas.com 1 4 * * * cd /var/www/Supporting_Scripts/expired_accounts_disable_nyse/; php expired_accounts_disable_nyse.php -l35 -m250 #Owner: Dave Mabe. This script looks for those users that are deemed as "professional" and notifies them via email to take action(to sign up as a Professional instead of remaining "regular" user). If the time period elapses with no action taken, they are disabled. The users database table is queried and might be updated during this process. MAILTO=dmabe@trade-ideas.com,kathleen@trade-ideas.com,william@trade-ideas.com 0 5 * * * cd /var/www/Supporting_Scripts/nyse_weasel_expirations/; php nyse_weasel_expirations.php -m200 #Owner: Dave Mabe -Subscriber History script MAILTO=dmabe@trade-ideas.com,kathleen@trade-ideas.com,william@trade-ideas.com 0 17 * * * cd /var/www/Supporting_Scripts/subscriber_history; php subscriber_history.php > /dev/null #Owner: Dave Mabe. This script queries the user cookie table then updates an #archive table within the database that reflects which users are on over time. MAILTO=dmabe@trade-ideas.com,michael@trade-ideas.com,kathleen@trade-ideas.com,william@trade-ideas.com */15 * * * * cd /var/www/Supporting_Scripts/currently_on_archive;php currently_on_archive.php -n 0 0 * * * cd /var/www/Supporting_Scripts/currently_on_archive;php currently_on_archive.php -d 0 0 * * 0 cd /var/www/Supporting_Scripts/currently_on_archive;php currently_on_archive.php -w 1 0 1 * * cd /var/www/Supporting_Scripts/currently_on_archive;php currently_on_archive.php -m 1 0 30 6,9 * cd /var/www/Supporting_Scripts/currently_on_archive;php currently_on_archive.php -q 1 0 31 3,12 * cd /var/www/Supporting_Scripts/currently_on_archive;php currently_on_archive.php -q #This script (owner: Kathy L) looks at the grandfathering table each day and determines whether an email #should be expired based upon whether it is associated with active subscription in Chargebee. #Details- it seeks all affiliate-customer associations within the granfathering table(leaddyno #_grandfathering) that are marked as 'active' then checks them against Chargebee #to see if that subscription is still active. If it's not, then that associateion is marked as "expired". #This script may read and update the table leaddyno_grandfathering MAILTO=kathleen@trade-ideas.com,william@trade-ideas.com 30 4 * * * cd /var/www/Supporting_Scripts/gf_table_retirement/; php grandFatherCheckForCancels.php -r MAILTO=kathleen@trade-ideas.com # This script looks at the grandfathering table each day and determines whether an email should be expired based upon whether it is associated with active subscription in Stripe #30 4 * * * cd /var/www/Supporting_Scripts/gf_table_retirement/; php grandFatherCheckForCancelsStripe.php -r #Owner: Kathy. This script, ib_retrieve_intraday.php, is designed to read the intraday files from IB's ftp site,Monday-Friday #checking for any customer subscribe/cancel events. This script polls the ftp site every 15 minutes. Subscribe/cancel #events are processed with the appropriate authorization_expire set on our end. The database tables involved are read #and written to. Tables mentioned in this script: users, ib_integration_processed, ib_intraday_datetime_strings MAILTO=kathleen@trade-ideas.com,william@trade-ideas.com */15 0-23 * * 1-5 cd /var/www/Supporting_Scripts/ib_subscription_integration/; php ib_retrieve_intraday.php -r MAILTO=kathleen@trade-ideas.com #Owner: Kathy. This script, ib_retrieve_intraday.php, is designed to read the intraday files from IB's ftp site,Monday-Friday #checking for any customer subscribe/cancel events. This script polls the ftp site every 15 minute. Subscribe/cancel #events are processed with the appropriate authorization_expire set on our end. The database tables invovlved are read #and written to. Tables mentioned in this script: users, ib_integration_processed, ib_intraday_datetime_strings #*/15 0-23 * * 1-5 cd /var/www/Supporting_Scripts/ib_subscription_integration/; php ib_retrieve_intraday_stripe.php -r #Owner: Kathy This script processes the monthly referral commissions for Shari. It runs on the first day of each month, and processes referrals #for the #previous month. Our database tables are not used in this script. We do however, make cURL requests with the Tune API. #MAILTO=kathleen@trade-ideas.com,william@trade-ideas.com #30 4 1 * * cd /var/www/Supporting_Scripts/end_of_month_referrals/; php tuneMonthlyReferralCron.php -r # Owner:Kathy. This "backstop" script is run very early each day (3:00 am) to check whether the previous day's chargebee payemnts are represented in the aggregate_revenue database table. It uses the Chargebee API to gather the relevant invoice data. If payment is not noticed, an email is produced and sent to a designated contact. MAILTO=kathleen@trade-ideas.com,william@trade-ideas.com 00 3 * * * cd /var/www/Supporting_Scripts/chargebee_payment_reconcile/; php reconcileCBPayments.php -d MAILTO=kathleen@trade-ideas.com #This script is run very early each day (3:00 am) to check whether the previous day's Stripe payemnts are represented in the aggregate_revenue table 00 03 * * * cd /var/www/Supporting_Scripts/chargebee_payment_reconcile/; php reconcileStripePayments.php -d # Owner:Kathy. This script runs every 15 minutes to get needed data from Brightback pause and extension type offers by using Chargebee API calls. # The brightback_pending_requests table and brightback_coupon_activity table are involved during this process. MAILTO=kathleen@trade-ideas.com,william@trade-ideas.com */15 * * * * cd /var/www/Supporting_Scripts/brightback/; php processBrightbackRequests.php -r # Owner: Kathy. This script runs every morning. It checks each entry in the brightback_coupon_activity table to see whether the Brightback related coupon has already expired for the subscription in question. MAILTO=kathleen@trade-ideas.com,william@trade-ideas.com 30 2 * * * cd /var/www/Supporting_Scripts/brightback/; php brightbackCouponCron.php -r #Owner: Kathy.This script queries invoice info through the Chargebee API and updates the tune_refund_reconciliation table, which Marissa uses when she does refund reports. MAILTO=kathleen@trade-ideas.com,william@trade-ideas.com 30 3 * * * cd /var/www/Supporting_Scripts/tuneReconTable/; php updateTuneReconCron.php -r #Owner: Kathy. Once every morning, this script makes Tune API calls to fetch conversion data and update the tune_affiliate_performance table. MAILTO=kathleen@trade-ideas.com,william@trade-ideas.com 30 3 * * * cd /var/www/Supporting_Scripts/AffiliatePerformanceTableUpdate/; php update_affiliate_performance.php -r update #Owner: Dave Mabe Once each weekday evening, this command is run to start the AI overnight server. It shuts itself down upon successful completion of it's nightly task MAILTO=dmabe@trade-ideas.com,william@trade-ideas.com 0 20 * * 1-5 /usr/local/bin/aws ec2 start-instances --instance-ids i-0888b34c28a94d7f1 #This script runs the email/sms process at the start of premarket hours(5:00 am PST) and will end on its own after the postmarket hours(4:00 PST). This is designed to run on weekdays MAILTO=kathleen@trade-ideas.com,william@trade-ideas.com 0 1 * * 1-5 cd /var/www/Supporting_Scripts/alerts_email_sms/; php alerts_email_sms.php -c -l #Owner: Dave Mabe - ends any tournaments that are scheduled to end on the current day. Should run right at the market close MAILTO=dmabe@trade-ideas.com,william@trade-ideas.com 0 13 * * 1-5 cd /var/www/Supporting_Scripts/contests/; php end_contest.php #Owner: Dave Mabe - starts any contests that need starting and add any new users to running contests MAILTO=dmabe@trade-ideas.com,william@trade-ideas.com */5 * * * * cd /var/www/Supporting_Scripts/contests/; php start_contest.php */6 * * * * cd /var/www/Supporting_Scripts/contests/; php sync_symbol_lists.php > /dev/null #Owner: Kathy. This script ensures that the table containing the tune affiliates is kept #updated - as new affiliates frequently sign up. (We want keep the entries within Back Offices' #the RevenueRecords table accurate.) MAILTO=kathleen@trade-ideas.com, william@trade-ideas.com 30 4 * * * cd /var/www/Supporting_Scripts/tune_affiliate_table/; php refresh_tune_affil_table.php -r #Owner: McKay. Script generates symbol lists based on countries for the global account MAILTO=christopher@trade-ideas.com, michael@trade-ideas.com 0 22 * * 0-4 cd /var/www/Supporting_Scripts/ ; php CountrySymbolLists.php 0 22 * * * cd /var/www/Supporting_Scripts/ ;php broker_authorization_updates.php [mfranz@ti-prod-use1-generatealerts-01 ~]$ crontab -l # MIN HOUR DAY MONTH DAYOFWEEK COMMAND # this scans for splits in our database that don't look correct MAILTO=brad@trade-ideas.com,michael@trade-ideas.com,kathleen@trade-ideas.com 0 20 * * * cd /ti/SupportingScripts ; php SplitsAudit.php 5 MAILTO=michael@trade-ideas.com #SupportingScripts 25,55 4,5,6,7,8,9,10,11,12,13 * * 1-5 cd /ti/SupportingScripts ; php WallStreetHorizon.php now update > /tmp/WallStreetHorizonsDateBreaks.log 55 17 * * 1-5 cd /ti/SupportingScripts;php archive_alerts.php; php CheckArchiveAlerts.php #temp fix for splits problem 40 2 * * 0-6 cd /ti/SupportingScripts;./FixSplits;./FixOvernight 0 15 * * 0-6 cd /ti/SupportingScripts;./FixSplits;./FixOvernight #realtime_alerts 0 14 * * 1-5 cd /ti/generatealerts/data ; mv black-list.txt /tmp ; touch black-list.txt 30 17 * * 0-4 cd /ti/generatealerts/run/early;./run 30 17 * * 0-4 cd /ti/generatealerts/run/late;./run #overnight symbols 0 19 * * 1-5 cd /ti/generatealerts/overnight_symbol_lists/;./run > log_early.txt 55 3 * * 1-5 cd /ti/generatealerts/overnight_symbol_lists/;./run > log_late.txt #TIQ WESTON 35 17 * * 0-4 cd /ti/generatealerts/tcl; ./run 0 21 * * * cd /ti/generatealerts/tcl/Logs; find . -maxdepth 1 -name 'log.*[0-9]' -atime +10 -exec gzip -9v {} \; 2>>clean.txt ; find . -maxdepth 1 -name 'log.*.gz' -exec mv --no-clobber {} old \; 0 16 * * 1-5 /ti/SupportingScripts/ResetWeston #FACTSET 30 0,2,4,5,6,7,8 * * * cd /ti/generatealerts/overnight_factset ; ./start_overnight_factset #factset for brad 0 4 * * 1-5 cd /ti/generatealerts/overnight_factset;scp *.csv ti-prod-use1-productweb-01:/var/www/alldocs/stats/factset/ #generic overnight csv scripts #Flash SEC (Float, Outstanding Shares) 15 1 * * 1-5 cd /ti/generatealerts/overnight_generic_csv;./process_flash_sec #midday updates for Flash SEC 0 15 * * 1-5 cd /ti/generatealerts/overnight_generic_csv/flash_sec_midday; ./cleanup.sh; python get_json.py > baseline.json 10 04 * * 1-5 cd /ti/generatealerts/overnight_generic_csv/flash_sec_midday; ./midday_update.sh 01 10 06 * * 1-5 cd /ti/generatealerts/overnight_generic_csv/flash_sec_midday; ./midday_update.sh 02 10 08 * * 1-5 cd /ti/generatealerts/overnight_generic_csv/flash_sec_midday; ./midday_update.sh 03 10 10 * * 1-5 cd /ti/generatealerts/overnight_generic_csv/flash_sec_midday; ./midday_update.sh 04 10 12 * * 1-5 cd /ti/generatealerts/overnight_generic_csv/flash_sec_midday; ./midday_update.sh 05 #trim alerts, alerts_daily average, special symbols 30 21 * * 1-5 (cd /ti/SupportingScripts;./save_nasdaq;./save_nyse;php update_averages.php;./trim_alerts_atomic >/tmp/trim_alerts_atomic.txt;./Update_Special_Symbols) #probably should move */2 * * * * cd /ti/SupportingScripts/; php copy_barries_list.php