Hello, I have purchased AVReporter Advanced Edition for my company, and I am trying to import some data via Connection Center module. However there are some things, that are not clear about scheduling: 1, Should Execute Now immediately start the enabled job ? 2, Should Interval Starts with Service start the job when the service starts or is re-started ? 3, Why is the Success box never checked ? Shouldn't this indicate if a job executed successfully ? 4, If a particular run of a job takes longer than 30 minutes will the next run start as soon as the previous one ended or will it wait until the next 30 minute boundary? 5, I am trying to import data from ION Enterprise. How can I adjust this to not retrieve data for all of the sources? For example, I may choose to pull data for some specific sources of interest.
Hi, and welcome to our forums! The answers to the questions are the following: 1, Should Execute Now immediately start the enabled job ? It does immediately start the job but this happens parallelly to the scheduler service. This means that starting jobs by pressing "Execute now" has the following characteristics: - You can start only one job at the same time this way. - The service may also start the job if it has been configured so. It's best to avoid such overlapping as it has been seen causing errors. - Table "Jobs" and the service log do not say anything about jobs started manually. Their results are displayed in a popup window once they finish or are interrupted. 2, Should Interval Starts with Service start the job when the service starts or is re-started ? The job will not start immediately, only the counter. The job will start when the counter reaches "wait interval in minutes". Let's say you checked "interval starts with service" and your job is scheduled to run periodically every 45 minutes. If you start the service at 12:00 then the job will run at 12:45 for the first time, 13:30 for the second time and so on. 3, Why is the Success box never checked ? Shouldn't this indicate if a job executed successfully ? What you see in table "Jobs" only shows the status of jobs executed by the scheduler service. If you click "Execute now" and run the job manually the table will not show anything about its status (nor will the service log). Success/failure and log messages of a manually executed job are shown in a window popping up when it has finished running. 4, If a particular run of a job takes longer than 30 minutes will the next run start as soon as the previous one ended or will it wait until the next 30 minute boundary? It will wait until the next boundary. 5, I am trying to import data from ION Enterprise. How can I adjust this to not retrieve data for all of the sources? For example, I may choose to pull data for some specific sources of interest. This can be done using filters. They can be set separately for every configuration of a configuration group. In case of ION, check "Show advanced options", open one of the configurations and go to tab "Connection". You will see a a field labelled "Filter". What you write here will be used in the SQL WHERE clause when reading data from the source database so rows excluded by this filter will be excluded from the importation process as well. An example: you have an ION database with several devices but only want to import data logged by two of them. One way to do this is filtering by source ID. Let's say these two devices have IDs "4" and "5" in table "Source" of ION. You need to create a configuration group based on the ION template and set these filters for the following configurations: - Source: use filter "ID IN (4, 5)" - DataLogStamp: use filter "SourceID IN (4, 5)" - DataLog: use filter "DataLogStampID IN (SELECT ID FROM DataLogStamp WHERE SourceID IN (4, 5))" Please tell us if the answers were satisfying!
