README

A simple Laravel package that automatically logs all jobs queued and processed by your application to the database. It listens to Laravel's built-in Job Events to record information without wrapping or modifying the Queue itself. Ships with configurable table names, a swappable Eloquent model, and a built-in prune command to manage retention.

Requirements

• PHP 8.4+
• Laravel 13+

Installation

You can install the package via composer:

composer require codeldev/laravel-job-log

You can publish and run the migrations with:

php artisan vendor:publish --tag="job-log-migrations"
php artisan migrate

You can publish the config file with:

php artisan vendor:publish --tag="job-log-config"

This is the contents of the published config file:

return [
    'prune_days' => (int) env('JOB_LOG_PRUNE_DAYS', 365),
    'model' => CodelDev\LaravelJobLog\Models\LaravelJobLog::class,
    'table' => env('JOB_LOG_TABLE', 'job_log'),
];

Environment Variables

The following env variables are available to configure the package using your env file.

JOB_LOG_PRUNE_DAYS=365
JOB_LOG_TABLE=job_log

Usage

Once installed, the package automatically logs every job. No additional setup is required.

Pruning Old Records

Add to your routes/console.php file:

Schedule::command('job-log:prune')
    ->weeklyOn(1, '02:30')
    ->withoutOverlapping();

Run manually:

php artisan job-log:prune

Querying the Data

The package provides an Eloquent model you can use directly:

use CodelDev\LaravelJobLog\Models\LaravelJobLog;
use CodelDev\LaravelJobLog\Enums\LaravelJobRunStatusEnum;

// Get all logs
LaravelJobLog::all();

// Filter by status
LaravelJobLog::query()
->where('status', LaravelJobRunStatusEnum::SUCCEEDED)
->get();

LaravelJobLog::query()
->where('status', LaravelJobRunStatusEnum::FAILED)
->get();

LaravelJobLog::query()
->where('status', LaravelJobRunStatusEnum::RUNNING)
->get();

// Filter by job class
LaravelJobLog::query()
    ->where('job', 'App\\Jobs\\MyJob')
    ->get();

// Filter by queue
LaravelJobLog::query()
    ->where('queue', 'default')
    ->get();

// Jobs from the last 24 hours
LaravelJobLog::query()
    ->where('started_at', '>=', now()->subDay())
    ->get();

// Slow jobs (over 1 second)
LaravelJobLog::query()
    ->where('duration_ms', '>', 1000)
    ->orderBy('duration_ms', 'desc')
    ->get();

// Failed jobs with exception details
LaravelJobLog::query()
    ->where('status', LaravelJobRunStatusEnum::FAILED)
    ->with('failedJob')
    ->get();

// Paginate results
LaravelJobLog::query()
    ->orderBy('created_at', 'desc')
    ->paginate(15);

Available Fields

LaravelJobLog

LaravelJobFailed (read-only view of Laravel's failed_jobs table)

The LaravelJobLog model has a failedJob() relationship that links to LaravelJobFailed via the failed_job_id column, giving you access to the full exception details for failed jobs.

Using a Custom Model

You can extend the package model to add your own behaviour, scopes, or relationships. Create your custom model, extend the package model, then update the config:

use CodelDev\LaravelJobLog\Models\LaravelJobLog as BaseJobLog;

class JobLog extends BaseJobLog
{
    public function scopeFailed($query)
    {
        return $query->where('status', LaravelJobRunStatusEnum::FAILED);
    }
}

Then in config/job-log.php:

'model' => \App\Models\JobLog::class,

Testing

composer test

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

• CodelDev

License

The MIT License (MIT). Please see License File for more information.