I added a custom cron job and it appears in cron_schedule table but pending or missed need to know what is happening in the background to check if there is any error
Do you have a lot of other cron processes running as well? Any long running ones? I believe a cron will be missed if Magento doesn't get around to it on this cron run because it's too busy with other cron processes.
Can you try running it manually with someone like on here: https://magento.stackexchange.com/questions/122081/magento-2-execute-cron
If that succeeds, and you see that the cron is running in the schedule then it should eventually run.