'Crontab not working properly but log shows the opposite

im working on a small ETL that collects data using webscraping, cleans and manipulates it and sends to a local sqlite3 database.

If i execute the command /virtualenv_path/python /script_path/script.py it runs perfectly, but if i schedule this command with crontab it does not work.

It just does not send any data. However, my log file shows me that the crontab is executing script.py using my venv as expected.

So, what is going on? What should i do to solve this?

I suppose that my script is not incorrect because if i execute without crontab it works flawlessly and even with crontab it does not show any error (as i said, log file suggests that everything is going really well)

this is my repository: https://github.com/raposofrct/wescraping-ETL there we have ETL folder that contains my script, crontab command that im using and my sqlite database.

thanks for any help or clue that you guys can give me.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source