Menu

#6 Sigvi Build in Scheduler - Change Execution Time

v1.0_(example)
open
nobody
None
5
2016-03-02
2016-02-26
SecMgr
No

Hi,

currently the daily reports
SIGVI, daily vulnerability report,
Security report [Daily report] and
* Vulnerability evolution [Daily report]
are scheduled and distributes every day at 12:00 am. As fare as I understand this is configure within the Sigvi internal scheduler and not in crontab.

As fare as I see there is the database table called tasks.

I wonder if it possible to change it to 06:00 am. Will it be safe if I perform the changes within the database table or will I have to follow an other procedure to do so?

Please advice.

Thank you in advance.
Chers Andreas

Discussion

  • SecMgr

    SecMgr - 2016-02-26

    I appologize for my impatience. I already executed the following updates within the table tasks and will check if it works tomorrow.

    / --------------------------------------------------/
    / SIVGI TASK SCHEDULING (change entries) /
    UPDATE sigvi.tasks SET hour = '06:00' where id_ptl = 1;
    UPDATE sigvi.tasks SET hour = '06:00' where id_ptl = 2;
    UPDATE sigvi.tasks SET hour = '06:00' where id_ptl = 3;
    UPDATE sigvi.tasks SET hour = '06:00' where id_ptl = 6;
    UPDATE sigvi.tasks SET hour = '06:00' where id_ptl = 7;
    UPDATE sigvi.tasks SET hour = '06:00' where id_ptl = 8;

    Now the table looks:
    1 40 Check repository Updates /plugins/cron/check_repository_updates.php Sync with NSDi daily 06:00 1
    2 20 Load Vulnerabilities /plugins/cron/load_vulnerabilities.php Load the vulnerabilities from the sources and insert them into the database daily 06:00 1
    3 30 Check server vulnerabilities /my_include/cron/check_server_vulnerabilities.php Search for vulnerable software on servers daily 06:00 1
    6 99 Reports /include/cron/report_launcher.php Generate the reports and send them to subscriptions daily 06:00 1
    7 50 Load product dictionaries /plugins/cron/load_products.php Load CPE products dictionary, using sources defined at sources management. daily 06:00 1
    8 10 Autovalidate alerts /my_include/cron/autovalidate_alerts.php Autovalidate alerts for periods major to application parameter auto_validate_after daily 06:00 1

     

    Last edit: SecMgr 2016-03-02
  • SecMgr

    SecMgr - 2016-03-02

    The change worked fine.
    Service request can be closed.

     

Log in to post a comment.