my cron jobs will refresh nearlly all the DW datasets everyday, but sometimes job will fail because of a lock on the table, what i do is to kill the job which is holding a lock and run the job.
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss. Register now and lock in 2025 pricing—just $495!