To run from command prompt:
- Logon to application server
- Click Start > All Programs > Accessories > Command Prompt
- Go to the drive that 'ECOMETRY' is on
- Example: For example, if Ecometry is on drive E, type E: and press Enter
- Change directory to ECOMETRY\<code account>\Pro folder
- Example: Type cd ECOMETRY\LIVECODE\Pro and press Enter
- Type cronsched and press Enter
- Command window will display command line parameter options
- The necessary parameters are:
- Stream File Name – file name of stream to run
- DB User Name – database user name for account where stream will run
- For SQL database, the database user name entered for this parameter must be the same as that specified for "User ID=" on the ADO line of the <account>.ini file specified in the <path and account.ini filename> parameter for the cronsched command
- For Oracle database, the database user name entered for this parameter must be the same as that specified for "Data Source=" on the ADO line of the <account>.ini file specified in the <path and account.ini filename> parameter for the cronsched command
- VisualLink Listener Port – port number of VisualLink listener for account job is being run on
- Must be numeric port number
- Cannot use alias
- Path and account.ini filename – full path and .ini file name of account job is being run on
- Example: If account name is ECOMLIVE and ini file is located in E:\ECOMETRY\LISTENER, then parameter would be E:\ECOMETRY\LISTENER\ECOMLIVE.ini
- Type cronsched command with parameters and press Enter
- Example: cronsched userlist mgr 31000 E:\ECOMETRY\LISTENER\ECOMLIVE.ini
- Command Prompt window displays job number and stdlist location
- When job completes, type exit at prompt and press Enter
- Command Prompt window will close
To run from batch file:
- Logon to application server
- Click Start > All Programs > Accessories > Notepad
- The necessary parameters are:
- Path to Pro Folder – path of PRO folder of account where cronsched.exe will run
- Example: E:\ECOMETRY\LIVECODE\Pro
- Stream File Name – file name of stream to run
- DB User Name – database user name for account where stream will run
- For SQL database, the database user name entered for this parameter must be the same as that specified for "User ID=" on the ADO line of the <account>.ini file specified in the <path and account.ini filename> parameter for the cronsched command
- For Oracle database, the database user name entered for this parameter must be the same as that specified for "Data Source=" on the ADO line of the <account>.ini file specified in the <path and account.ini filename> parameter for the cronsched command
- VisualLink Listener Port – port number of VisualLink listener for account job is being run on
- Must be numeric port number
- Cannot use alias
- Path and account.ini filename – full path and .ini file name of account job is being run on
- Example: If account name is ECOMLIVE and ini file is located in E:\ECOMETRY\LISTENER, then parameter would be E:\ECOMETRY\LISTENER\ECOMLIVE.ini
- Cronshed command has following syntax:
<Path to Pro Folder>cronsched.exe <Stream File Name> <DB User Name> <VisualLink Listener Port> <path and account.ini filename>
- All text should be on one line with no line break
- Example:
E:\ECOMETRY\LIVECODE\Pro\cronsched.exe userlist mgr 31000 E:\ECOMETRY\LISTENER\ECOMLIVE.ini
- After typing command, select File > Save As ... from menu
- Navigate to ECOMETRY\<code account>\Userstr2 folder
- Example: E:\ECOMETRY\LIVECODE\Userstr2
- In File Name box, type the filename with .bat extension in quotes
- Click Save button
- Click Start > All Programs > Accessories > Windows Explorer
- Navigate to the folder where the batch file was saved
- Double-click filename to execute job
- Command Prompt window will open and display job number
- Command Prompt windows automatically closes when job complete