Skip to main content
Question

Best practices in scheduling fme.exe in SSMS

  • December 8, 2021
  • 2 replies
  • 65 views

bruceharold
Supporter
Forum|alt.badge.img+19

Hi All, I have a customer who is scheduling fme.exe from within Microsoft SSMS - because it has good logging functionality. The fme.exe command is taken from a desktop log file on the server machine. If they run the command in a shell it works, and scheduling with Task Scheduler works, but from inside SSMS as the sql_agent account they get 'FME license system failure: License dependency check failed. This FME suite license is dependent on another license which is not available. Program terminating. Transaction failed. Process exit code 2. The step failed. '. Does anyone have an idea what is the issue? SSMS scheduler has only the one user account available to run jobs, but I assume that could be changed. Thanks.

2 replies

salvaleonrp
Enthusiast
Forum|alt.badge.img+20
  • Enthusiast
  • December 9, 2021

Just to add to Bruce's note, the user is a SQL Server Agent Service account. It is the only option available when a step is created.


bruceharold
Supporter
Forum|alt.badge.img+19
  • Author
  • Supporter
  • December 9, 2021

Just to add to Bruce's note, the user is a SQL Server Agent Service account. It is the only option available when a step is created.

...and the user has Data Interoperability licensed as concurrent user - thanks.