Running Mapinfo pro with mapbasic mbx from sql agent job

[Chrissie Hind]

Hi all

I amtrying to call mapinfo professional 19 from an MS SQL agent job by running a local powershell script that simply throws it to the GIS application server where Mapinfo pro is installed and running the command line.

Here is the script in the job:

powershell "D:\Extracts\PS_MapBasicPS1.ps1"  - this D is the SQL server local drive.

This is the line in the ps1 script:

Invoke-Command -ComputerName "GISserverName" -ScriptBlock {Invoke-Expression -Command:"cmd.exe /c 'C:\progra~1\MapInfo\Professional\MapInfoPro.exe -noserver D:\IntraMaps\Scripts\MapBasic\MI_CreateTABIndex.MBX'"}

Task manager on GIS server shows mapinfopro.exe is running, and the command line shows as: 

C:\progra~1\MapInfo\Professional\MapInfoPro.exe -noserver D:\IntraMaps\Scripts\MapBasic\MI_CreateTABIndex.MBX

But the mbx does not actually do anything.  It literally just opens a file and drops and adds new indexes to a mapinfo table.  This command works fine if run on the GIS server either through a shortcut or via a batch file.  It just seems that Mapinfo does not want to run the mbx.

Any clues here?