All batch jobs stops automatically in night

(0) Share

Report

Posted on by Vishnu Prakash

Hi,

I am facing one strange issue in AX 2012 FP that all batch jobs are running fine during the day but at night 11 PM they are stuck in Executing status. Next day morning when we check the batch jobs then we find that all of them are still executing so we cancel them and then change the status to waiting then they immediately pickup and start running fine. The batch job which gets stuck is having recurrence of 15 min and other which are having one day recurrence are running fine. I have checked the Batch server timings etc and all seem to be fine (00:00:00 to 23:59:00).

Can anyone suggest me that what could be the issue?

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Verified answer

Vishnu Prakash 65 on at

Like (0)

Report

RE: All batch jobs stops automatically in night

Thanks to all of you for your suggestions.

The case is solved now. It is found that one of the job gets stopped due to some wrong parameter setup in night and that put all other jobs on hold i.e. none of the other job started until it got finished. When next day we were resuming the culprit job and then it all was allowing other jobs to run after finishing itself.

Thanks

Was this reply helpful? Yes No
Suggested answer

Zaheen82 on at

Like (0)

Report

RE: All batch jobs stops automatically in night

Hello,

Have you check if there is any issue with your services. Maybe some services are off or not working properly after 11 pm.

Regards

Zaheen

Was this reply helpful? Yes No
Guy Terry 28,874 Moderator on at

Like (0)

Report

RE: All batch jobs stops automatically in night

Hi Vishnu,

I have seen backup software that takes a snapshot of the server - I guess this is most common in scenarios where the server running SQL is virtualised. The process of taking a snapshot was causing the database to disappear, and playing merry havoc with any overnight batch jobs that were running at the time.

If this was the case, I would expect to see error messages in the Application logs on the server that runs the batch AOS, complaining about the database. And I imagine something in the Event viewer on the SQL box would show that some backup process had started - even if it was just an informational message.

Was this reply helpful? Yes No
Martin Dráb 236,118 Most Valuable Professional on at

Like (0)

Report

RE: All batch jobs stops automatically in night

Sure, you can find history of backups. Look at SQL SERVER – Get Database Backup History for a Single Database, for example.

Was this reply helpful? Yes No
Vishnu Prakash 65 on at

Like (0)

Report

RE: All batch jobs stops automatically in night

I don't have this information as i don't handle the back up etc for this client. Can i confirm it from some logs etc?

Was this reply helpful? Yes No
Guy Terry 28,874 Moderator on at

Like (0)

Report

RE: All batch jobs stops automatically in night

Have you got something that is taking a backup of the server on which SQL runs?

Was this reply helpful? Yes No
Vishnu Prakash 65 on at

Like (0)

Report

RE: All batch jobs stops automatically in night

Hi All,

Thanks a lot to you for your suggestions. I have checked the DB scheduling and it is taking DB backup at around 1 AM each night and Logs are backed up after every 3 hours without any errors.

I couldn't find any suspicious thing in AOS server event viewer also. But i checked in SQL server event viewer and i found that there was logon attempt around 11 PM each day which gets failed. Below is the message:

Login failed for user 'N10\__103010sql'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>].

But there were many more logon attempt failed at different times during the day so not sure if it was the main cause.

Any suggestion is welcome.

Thanks

Was this reply helpful? Yes No
BaidarBakhat on at

Like (0)

Report

RE: All batch jobs stops automatically in night

Hi Vishnu, Do u have any scheduled job [daily] with executing time of 11 pm onward?

Was this reply helpful? Yes No
Guy Terry 28,874 Moderator on at

Like (1)

Report

RE: All batch jobs stops automatically in night

Check the Windows event viewer (Application and System) on both the AOS(es) that are running the batch jobs, and on your SQL box, at around the time you see the problem.

Like the others, my money is on the database disappearing when a back up of some sort kicks in.

Was this reply helpful? Yes No
ALGDEV 355 on at

Like (0)

Report

RE: All batch jobs stops automatically in night

I think the BackUp dataBase

Was this reply helpful? Yes No