In CCR I just found that I can only schedule up to 100 email reports.. how do I increase this? I expect to schedule/send at least 500 reports.
I pinged some folks and found the following procedure that will address the max number of schedules.
You will need to run this from the mysql command prompt on the CCR server:
I've been looking into this and found a solution. The number of scheduled emails can be configured via the database, but that parameter has to be manually added otherwise the default value is used (100). To set a new limit, run the following query in the netqosportal database:
REPLACE INTO general VALUES ("Email.ScheduleLimit", "500");
maybe dumb question.. but noobie here.. do I go to the datamanager directory - enter 'mysql netqosportal' and at the 'mysql' prompt... copy your statement and paste it? how do I commit it or does it automatically?
Thats is not a dumb question , mysql is used by the netqqs report engine .
You have to go to \NETQOS\mysql51\bin
a other approach is to go to the netqqs/ccr special setting page and add the parameter here using the webpage
This opens a hidden setting page
Dirk, that change to the global settings worked .. thanks