subMinutes(3)->copy();
$one_hour_ago=Carbon::now()->subMinute(59)->copy();
$this->info($now->toDateTimeString() . '| checking for hanged job(s) ...');
$data = CronJobStat::where([
['name', '<>', 'DLR_QUERY'],
['name', '<>', 'EMAIL_QUERY'],
['last_run', '<', $three_min_ago->toDateTimeString()]
])->get();
$html = 'MTN MESSENGER Alert!!!
';
$html .= 'Date: '.$now->toDateTimeString().'
';
$html .= 'Hello Team, this is an automated email alert sent from MTN MESSENGER.
The scheduled tasks (cronjob) below have not been running for the past 3min
';
$html .= '';
$html .= '| Last Run | Status | Source | Description |
|---|
';
foreach ($data as $record) {
$html .= '| '.$record->last_run.' | '.$record->status.' | '.$record->name.' | '.$record->description.' |
';
}
$html .= '
';
if($data->count()>0) {
$this->info($now->toDateTimeString() . '| '.count($data).' hanged Job(s) found ...');
/*
Mail::send('emails.alert', ['html'=>$html], function ($m) {
$m_email = 'support@npontu.com';
$m->from($m_email, 'MESSENGER Alert');
$m->to('appengineer@npontu.com', 'Dev Team');
$m->cc('npontualph@gmail.com', 'Alphonse Malan');
$m->subject('MTN MESSENGER - Emergency!!');
});
*/
}
}
}