It doesn’t matter which queue system you’re using: Redis, a relational database such as MySQL or a cloud solution like AWS SQS ; you can always store failed jobs in a normal database table. This configuration is done in config/queue.php in the last array:
'failed' => [ 'driver' => 'database', 'database' => 'default', // NOTE: connection, not database! 'table' => 'jobs_failed', ],
The key is to put in the connection name, not the database name for ‚database‘. If you don’t you will get the error message „Database default not configured“ every time a job fails instead.
Check out my Laravel Job Eloquent Models.