IIS Application Pool Settings
Application Pool Recycling
After installing StarfishETL an application pool is created in IIS that will, by default, be set to recycle every 2740 minutes.
This may have an impact on scheduled jobs since the Application Pool may recycle while it is running causing the job to fail.
The Application Pool can be set to recycle on a different conditions and you should consider when to do this based on your schedule.
To get to the Application Pool recycling settings open IIS and expand the list of Application Pools. Highlight the Starfish Application Pool and click on 'Recycling...'. From here you can change the recycling conditions.
Note that changing the recycling conditions will cause the Application Pool to recycle when you click finish so ensure that there are no Starfish jobs running when you make a change.
Recycle On A Schedule
You may want to try setting the IIS Application Pool used by Starfish to recycle on a schedule. In IIS, you can set an Application Pool to recycle every x hours. You can also use Windows Task Scheduler to schedule an Application Pool Reset on a more complicated schedule. For example, if you have a large integration that runs over the weekend, you could use the Task Scheduler to recycle the pool Fridays just before the integration starts. To do this, create a new Task Scheduler with the desired schedule and "Start a program" C:\Windows\System32\inetsrv\appcmd.exe recycle apppool "StarfishETL". You may need to change the location of appcmd.exe or the name of the Application Pool to recycle. A quick internet search should be able to provide more guidance to recycling an Application Pool from the command line.