All Scheduled Agents not running for Specific Database on Server

Hi All,

I have also Checked log file, Yesterday it Is working fine, but Today its Showing not running any Scheduled Agents for Specific Database on Server. We can Check Agent Signer id, its working fine for another database.

Can any one please suggests What is Issue.

Thanks,

Shashi

You can refer to information provided in below URL -->

https://support.hcltechsw.com/csm?id=kb_article&sysparm_article=KB0032179

In past, steps suggested below has helped us to resolve this issue.

1) Can you please check if the database properties of the impacted database has been selected with 'Disable background agents for this database'
Make sure this property is disabled (Unchecked).

If 'Disable background agents for this database' is selected then any scheduled agent on this database will not run and also will not show in the amgr schedule list.
After altering this database property, restart AMGR task by issuing the below command.
TELL AMGR QUIT
LOAD AMGR

Now issue command "TELL AMGR SCHED" on server console and see if agent is displaying or not.
Note: Even if 'Disable background agents for this database' is unchecked, Please enable the setting and close the database properties.
Again go back to the database properties and uncheck this option. Now verify the situation by performing the Amgr quit and load command as mentioned above.

2) If issue persist we recommend to run maintenance on the impacted database and see if that helps.
Load fixup -f DB1.nsf
Load compact -c
Load updall -r

Regards,

Amit Sharma

Thanks Amit,

After Run this Command in Server Console Load fixup -f DB1.nsf Agent Start Running.

Glad that issue is resolved.

Regards,

Amit Sharma

Hi Shashi,

In addition to unchecking the property 'Disable background agents for this database'

1. please right-click the schedule agent and check the log of the agent.

This log will provide an idea about why the agent has not been run.

2. Please select the name of the server 'where the agent runs '

Hope above helps

Hello,

I have also found the case, after copying a database, where the scheduled agents are scheduled to run between 00:00 and 00:00 :

In this case, they will never run, and will also not appear in the agent manager schedule.