meta data for this page
  •  

This is an old revision of the document!

Scheduled processing

Automatically launching a query or a set of queries at regular intervals is a common need in companies. This is why Vigilens offers you a mechanism for scheduling your queries.

Principle

It simply uses Windows Task Scheduler to launch a command line. You can use either classic dos language (cmd) or Powershell.

Ex : C:\Vigilens\app\Vigilens.exe /vglAuto=“C:\Vigilens\Work\Archives\DEMO\foder\myquery” /vglUser=“SCHEDULE_FR”

Setup

You do it in AdminTool Batch output menu. #TBC

You have to define users who will be allowed to connect with a command line.

#TODO

Assistant

In Vigilens Designer, there is a scheduling assistant. Use it to create the skeleton of your command, and adapt it to your needs. See our URL syntax guide below.

User

If you want to be sure that a free connexion will be available at the moment job is triggered, it may be useful to create a specific user with "Vigilens Dedicated" profile type.

Syntax

/vglForceInstall

/vglExe=RequestName

  • run query RequestName
  • only shared queries are allowed for running
  • RequestName represents query relative path using shared directory as starting point, it means as it appears in Vigilens Designer GUI.

/vglAuto

  • Processes all queries inside a directory provided by user

/vglDir=DirectoryName

  • Automatic processing of all queries inside the directory given as a parameter
  • DirectoryName the full path for the directory to be processed, as it appears in the windows file explorer on machine processing the command-line.

/vglDirConf

  • profile used for automatic processing (/vglDir)

Starting with Windows Vista (or Server 2003), it is necessary to run this command as an administrator to allow processing by a task scheduler.

/vglUser=UserName

  • Used combined with /vglDir to specify a user other than default user (assuming it has been supplied by /vglDirConf)

/vglMail=AdresseMail

  • Used combined with /vglDir option to ask processing report (log) file to be sent

/vglNumFormat=DecimalsThousands

The numerical values returned will use :

  • the first character as the decimal separator.
  • the second as the thousands separator

/vglOutput=OutputType

  • This optionnal setup is used combined with /vglExe.
  • Force an output type other than the one defined at query level.
  • possible values are
    • Grid : default
    • PDF
    • XLS
    • TXT

/vglPDFType=PDFFileType

  • Specify PDF output type
  • possibles values are :
    • 0 Grid
    • 1 Report
  • this parameter is mandatory with /vglOutput=PDF .

/vglPDFModel=ModeleImpression

  • Spécifie le modèle d’état ou d’impression de la grille.
  • ce paramètre est obligatoire avec le paramètre vglOutput=PDF

/vglMaxLineNumber=Valeur

  • Spécifie le nombre maximum d’enregistrements à restituer.
  • Au-delà l’exécution de la requête s’arrête et renvoie un message d’erreur.
  • Ce paramètre permet de sécuriser l’emploi des ressources machine.

Passage de paramètres

  • Les valeurs des paramètres à l’exécution sont spécifiées dans la ligne de commande en utilisant leur code court
  • syntaxe : /CodeCourt=ValeurSelectionnee
  • On peut ne pas les prendre en compte (autoriser toutes valeurs) par le caractère * en lieu et place de la valeur de sélection

[contenu][✓ erica, 2020-07-06]à faire
[orthographe][✓ jacobt, 2020-07-06]à faire
[liens_internes][✓ jacobt, 2020-07-06]à faire
[liens_casss][✓ jacobt, 2020-07-06]à faire
[page_absente][✓ jacobt, 2020-07-06]à faire
[todo][✓ jacobt, 2020-07-06]à faire
[coherence_graphique][✓ jacobt, 2020-07-06]à faire
[taille_images][✓ jacobt, 2020-07-06]à faire
[version_mobile][✓ jacobt, 2020-07-06]à faire
[version_anglaise]à faire