how to Set up database values to crontab jobs in magento

Question

in my config.xml file have crontab

.....
    <crontab>
            <jobs>
                <autoreplenish_test>
                    <schedule>
                        <config_path>how to set up here database values</config_path>
                    </schedule>
                    <run>
                        <model>autoreplenish/replenish::run</model>
                    </run>
                </autoreplenish_test>
            </jobs>
        </crontab>
...

Answer 1

These links might help you out

http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/how_to_setup_a_cron_job http://blog.belvg.com/magento-certified-developer-exam-setting-up-a-cron-job.html

Answer 2

        <crontab>
            <jobs>
                <autoreplenish_test>
                    <schedule>
                        <config_path>customsection/cronfield/cron_settings</config_path>
                    </schedule>
                    <run>
                        <model>autoreplenish/replenish::run</model>
                    </run>
                </autoreplenish_test>
            </jobs>
        </crontab>

this has worked for me!!

Answer 3

I think the best way to get this to work is to rewrite the Mage_Cron_Model_Schedule

<models>
    <your_module>
        <class>Your_Module_Model</class>
    </your_module>
    <cron>
        <rewrite>
            <schedule>Your_Module_Model_Schedule</schedule>
        </rewrite>
    </cron>
</models>

Then you would need to rewrite the function setCronExpr and update is so it tries to load the value from the database first and then defaults to the normal behaviour.

Note: You will have to check your xml back to cron_expr and what ever you store in the database should be a valid cron expression

See this question and answer combo for what is valid or not.

Answer 4

There are missing cron time interval on you code< i have set cron will run every 30mins interval

<cron_expr>30 * * * *</cron_expr>

more details http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/how_to_setup_a_cron_job

<crontab>
<jobs>
<autoreplenish_test>
<schedule><cron_expr>30 * * * *</cron_expr></schedule>
<run><model>autoreplenish/replenish::run</model></run>
</autoreplenish_test>
</jobs>
</crontab>