Forums - Thread Details
  • State Not Answered
  • Replies 2 replies
  • Subscribers 319 subscribers
  • Views 1200 views
  • Users 0 members are here
Forum Actions
Related

Why my custom scheduler is not running?

Itzel Cordero

I'm doing a custom scheduler to do a soft delete to a table and when i upload the package to sugar it doesn't show any error but it's not running. The status is active and there's no last execution. Also, the LBL does not show in the dropdown it's just a blank space. Here's a screenshot:

Here's my code

soft_delete_wsmonitor.php which is the custom scheduler:

<?php

array_push($job_strings, 'soft_delete_wsmonitor');
function soft_delete_wsmonitor()
{
global $db;
$conn = $db->getConection();
$query = "UPDATE wsmon_wsmonitor SET deleted = 1 WHERE date_entered < DATE_SUB(NOW(), INTERVAL 3 MONTH) LIMIT 50";
try {
$conn->executeQuery($query);
}
catch (DBALException $e) {
$GLOBALS['log']->fatal($e->getMessage());
} finally {
$conn->disconnect();
}
return true;
}

es_LA.soft_delete_wsmonitor.php which is the label extension file:

<?php

$mod_strings['LBL_CUSTOM_JOB'] = 'Soft Delete WSMonitor Records';

Parents
  • 0

    The custom label must follow the job's function name:

    $mod_strings['LBL_SOFT_DELETE_WSMONITOR'] = 'Soft Delete WS Monitor';

    Make sure cron is configured in your server (On Schedule's List View it is displayed the steps to configure it).

    Try to force running it (create a php script which loads such file) and double check the returned error.

    <?php
    if (!defined('sugarEntry')) define('sugarEntry', true);

    chdir(dirname(__FILE__));
    define('ENTRY_POINT_TYPE', 'api');
    require_once('include/entryPoint.php');

    SugarMetric_Manager::getInstance()->setMetricClass('background')->setTransactionName('cron');

    if(empty($current_language)) $current_language = $sugar_config['default_language'];

    $app_list_strings = return_app_list_strings_language($current_language);
    $app_strings = return_application_language($current_language);

    global $current_user;
    $current_user = BeanFactory::newBean('Users');
    $current_user->getSystemUser();

    // allow admin to access everything
    $adminWork = new AdminWork();
    $adminWork->startAdminWork();


    include 'custom/Extension/modules/Schedulers/Ext/ScheduledTasks/{the_script}.php';

    sugar_cleanup(false);

    if(class_exists('DBManagerFactory')) {
    $db = DBManagerFactory::getInstance();
    $db->disconnect();
    }

    if(session_id()) session_destroy();

    exit(0);

    Regards

    André Lopes
    Lampada Global
    Skype: andre.lampada
Reply
  • 0

    The custom label must follow the job's function name:

    $mod_strings['LBL_SOFT_DELETE_WSMONITOR'] = 'Soft Delete WS Monitor';

    Make sure cron is configured in your server (On Schedule's List View it is displayed the steps to configure it).

    Try to force running it (create a php script which loads such file) and double check the returned error.

    <?php
    if (!defined('sugarEntry')) define('sugarEntry', true);

    chdir(dirname(__FILE__));
    define('ENTRY_POINT_TYPE', 'api');
    require_once('include/entryPoint.php');

    SugarMetric_Manager::getInstance()->setMetricClass('background')->setTransactionName('cron');

    if(empty($current_language)) $current_language = $sugar_config['default_language'];

    $app_list_strings = return_app_list_strings_language($current_language);
    $app_strings = return_application_language($current_language);

    global $current_user;
    $current_user = BeanFactory::newBean('Users');
    $current_user->getSystemUser();

    // allow admin to access everything
    $adminWork = new AdminWork();
    $adminWork->startAdminWork();


    include 'custom/Extension/modules/Schedulers/Ext/ScheduledTasks/{the_script}.php';

    sugar_cleanup(false);

    if(class_exists('DBManagerFactory')) {
    $db = DBManagerFactory::getInstance();
    $db->disconnect();
    }

    if(session_id()) session_destroy();

    exit(0);

    Regards

    André Lopes
    Lampada Global
    Skype: andre.lampada
Children
No Data