The auto SQL import job updates command enables you to import job updates into DMS via a predefined SQL script.  This command is the same as selecting the Import | SQL Import | Job Updates Via SQL manually from the DMS menu.  The SQL script is defined using Import | Import Settings | Job Updates SQL Scripts.

In order to import job updates automatically, the user name provided for the login must have access to both the “Enable Auto User Login” and the “Import job updates using SQL”. 

The parameter for the automatic import jobs is:

       AutoSQLImportJobUpdates=command file        

For example, to login to the database WorkData with a user name of Jan Smith to import jobs via an SQL script using the command file C:\Program Files\Dynafact\Import Job Updates Cmd.TXT the following would be used:

"C:\Dynafact\Production\DMS\DMSEnt.exe" "UserIniFolder=C:\Dynafact\Production\DMS\User\" "AutoUserName=Jan Smith" DatabaseName=WorkData “AutoSQLImportJobUpdates=C:\Program Files\Dynafact\Import Job  Updates Cmd.TXT"        

The “command file” is an existing text file that holds the SQL import job updates command information.  The command file parameters must never be surrounded in quotation marks even if the parameter has a space in it.  The following commands are given in the schedule command file: 

1. SQLScriptName =(The name of the existing SQL script to run)
2. ReportStatusFilename=(Filename to write the import status and any errors to.  If not given, the default filename of import folder\ ImportSQLJobUpdatesStatus.TXT will be used.

The following example shows a command file that will run the SQL script "DMS SQL Job Updates" and write the import status to a file called "ReportStatusFilename=C:\Program Files\Dynafact\DMS\Export\SomeResults.Txt":

SQLScriptName=DMS SQL Job Updates

ReportStatusFilename=C:\Program Files\Dynafact\DMS\Export\SomeResults.Txt