Sigvi Build in Scheduler - Change Execution Time
Brought to you by:
tiochan
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
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
The change worked fine.
Service request can be closed.