Using forfiles, how do you search for date created rather than date modified?

See also questions close to this topic

• A large update statement in SQL Server

  I have to do an update statement on a table with a large number of records for 3 years, each month has a million of records.

  I have tried to use the batching script but it takes a long time and I cancel it before the end.

  Could you please suggest the most efficient way to do this task?

  Thank you in advance.

  Regards,

  The main code of the treatment is:

  UPDATE [XXXX_DWH].[Dwh].[Invoice]
  SET OrderingCustomerCode = SUBSTRING(orderingcustomercode, 2, 7)
  WHERE InvoicingYear = '2019' AND InvoicingMonth = '01'
  
• How to save colocalization report and log in headless mode: Fiji ImageJ2?

  I am trying to automate the procedure of comparing the colocalization in two images using the headless mode in Fiji.

  A brief procedure of what I am trying to do:

  1. Open an image, split channels, and close the blue and green channels.
  2. Open a second image and again split channels, and close the blue and green channels.
  3. Analyze the two red channel images using coloc 2 and save the log file.

  I have added the imagej source folder to the path, so here is the batch code I have so far:

  imagej-win64 --ij2 --headless MZ_104.0263.png -run "Split Channels" -run "Close" -run "Close" MZ_108.0951.png -run "Split Channels" -run "Close" -run "Close" -run "Coloc 2" 
  

  How do I proceed after this? Manipulating the various options that coloc 2 offers, then running it and then saving the report and the log files (using a naming scheme of my choice)?

  Also, I need to do this for multiple pairs of images, if there is a way to do that efficiently.

  If there are other ways of doing this task, those would be helpful as well.

  Any help will be much appreciated. I have attached the images I am using as well.

  Veerupaksh

  MZ_104.0263.png

  MZ_108.0951.png
• Getting batch status from batchlet (The job is launched from batchlet)

  I have a batch job which has to be repeated for the list. So I have created a Job with batchlet. This batchlet step will load the list and for each of the id's from the list, its going to launch the another job. Launching batch job works fine as expected. However I have to retrieve the batch status and wait for the sub job to be completed, in order to iterate the id's from the list.

  The job is launched using JobOperator and param using Properties class. And I'm trying to get the batchstatus or exitstatus using JobExecution class. however the jobExecution is not retrieving the batchstatus from the child job. Its giving the batch status of the parent job (which is batchlet). Hope I'm not confusing. Below code snippet will give better understanding.

  for (int i = 1; i <= rsList; i++) {
              long execId = jobOperator.start("gah-history-chunk-archive-job",jobParamProperties);
              JobInstance jobInstance = jobOperator.getJobInstance(execId);
              JobExecution jobExecution = jobOperator.getJobExecution(execId);
              logger.info("Instance id: "+jobInstance.getInstanceId());
              while(!jobExecution.getBatchStatus().toString().equals("COMPLETED") || !jobExecution.getBatchStatus().toString().equals("FAILED")) {
                  //Both batch status and exit status giving the status of this batchlet, not giving the status of gah-history-chunk-archive-job
  logger.info("Batch status is: "+jobExecution.getBatchStatus() +" Thread is sleeping for 5 seconds");
                  logger.info("Exit status:"+jobExecution.getExitStatus());
  
                  Thread.sleep(300);
              }
          }
  

  I want to know, how to retrieve batch or exit status of the job which is launched from the batchlet. The instance id is coming as expected. which is the sub job launched from batchlet