Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / My Application Server ...
Microsoft Dynamics SL (Archived)

My Application Server misses scheduled jobs

(0) ShareShare
ReportReport
Posted on by Erich Strelow F 16

We've got our Application Server up and running. We called it "Atom Ant".

We use Atom Ant mostly to run nightly Financial Transaction Transfer and to perform some transaction imports.

Recently I had to reschedule some tasks, and the following situation arises:

  1. I create a task and give it either a daily schedule or a one-time schedule.
  2. The task appears in the "Master task" list and seems right.
  3. When the Atom Ant reaches the scheduled time, nothing happens.
  4. The task does appear in the "Today's schedule" in "Late" status.
  5. The task never comes up in the "Current Queue".
  6. If I create a task with no schedule at all, it runs correctly.

It's like the Monday Night Football scheduled in your TVGuide, but you turn on the TV and nothing happens.

I also had to move Atom Ant to another machine. My guess is that the schedule information becomes wrong by some combination of "am/pm" "dd/mm" "mm/dd" that's different between computers.

Please help on any hint on this.

Regards.

*This post is locked for comments

  • Erich Strelow F Profile Picture
    Erich Strelow F 16 on at
    RE: My Application Server misses scheduled jobs

    Thanks, very insightful.

    Now it makes a lot of sense that the Requests table might be messed up after some trial-and-error and some automation I've made.

    Also, I'm moving my scheduling to the Windows Server schedule service, which has more powerful scheduling options. The Application Server still performs the job, though.

  • Verified answer
    Steve Wier Profile Picture
    Steve Wier 962 on at
    RE: My Application Server misses scheduled jobs

    I recall have a similar issue in an older version of SL.   The fix was to reset the application server tables.  There used to be a knowledge base document with instruction on how to accomplish the reset.  I pulled the following from an old support email that addressed a similar issue. The emails is from 2006 so take that into consideration.  I highly recommend opening a support tickets with SL since this fix involves manual changes to the system database.

    Prior to running the scripts, make notes of all your scheduled reports, you will need to recreate them.

    Make a backup of the system database.

    Then delete all the Application server records from these tables:

    DELETE FROM AppSrvRequest

    DELETE FROM ASRDatabase

    DELETE FROM ASRDistList

    DELETE FROM Scheduler

    DELETE FROM User_Reports

    DELETE FROM Template WHERE TemplateID LIKE 'SOLOMONDESKTOP%'

    DELETE FROM AppSrvlog

    Then, in SQL Server Enterprise Manager, drop the table AppSrvRequest.

    open the DSD_sTables.sql in Query Analyzer. This file is located in the Solomon IV\DB\Scripts\Sys\ and search for appsrvrequest table creation statement. Copy the syntax into Query

    Then recreate the index on AppSrvRequest. To do this right-click on the AppSrvRequest table, select "All Tasks", Manage Indexes, then click "New...".

    Type AppSrvRequest0 in the Index name box. Check the ID column. Also, on the "Index Options" check the "Clustered index" and the "Unique values" option. Then, click OK, then Close.

    Now, access Solomon and start AppServer and submit a new request.

    You should then be at Request Number 1.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

#1
Community Member Profile Picture

Community Member 136

#2
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 102 Super User 2025 Season 1

#3
REUser Profile Picture

REUser 8

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans