SQL Server Agent daily job indicates completed but stored procedure and tables indicate otherwise -- 2nd time in 4 years also on Sunday?

[George Lewycky]

0Hi

We have scheduled job running a console application daily. For some reason on Sunday's only the scheduler says it ran successfully but no email confirmation, table entries and the normal processing occurs.

This happens only on a Sunday and for no explained reason. No problem on the day before or after...

I think this also happened with Daylight Savings adjustment. Has anyone else encountered this?

Any ideas or suggestions

Environment is:

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)


Thanks in advance


George

[Erland Sommarskog]

Post by George Lewycky
We have scheduled job running a console application daily. For some
reason on Sunday's only the scheduler says it ran successfully but no
email confirmation, table entries and the normal processing occurs.
This happens only on a Sunday and for no explained reason. No problem on
the day before or after...
I think this also happened with Daylight Savings adjustment. Has anyone
else encountered this?

Does it happen every Sunday? Or did it only happen this Sunday? And
was this a Sunday when you went over to Daylight Savings where you are?

How is the email confirmation produced? By the console application or
is it supposed to be sent by Agent?

[George Lewycky]

Hi Erland,

Thanks for replying....
It not EVERY Sunday but up to 3/year and only on Sundays.
I checked the other dates and they didnt coincide with Daylight Savings.

The VB.NET console app produces the email and run the SQL generate GUIDs and updating other tables.

One oddity for a quick job with few records on Sunday it took almost two minutes. Could the DBMS (a timeout?), connection be down and yet the agent still ran and thought all went ok with the Console app reporting it back as successful even though no activity occurred??

I suspect some weekend maintenance we arent aware of being a culprit....

Researching around I found someone with a similar situation only with reports and data drive subscription and other possible leads but nothing clear and solid.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b4176895-5ef3-488d-8c68-57ef287a784c/datadriven-subscription-doesnt-send-out-an-email-but-job-history-shows-its-successfull?forum=sqlreportingservices

http://databaseadministration.aspcode.net/ppst/63547616526662281693706/package-deployed-in-ssis-2012-catalog-fails-with-timeout-error

http://stackoverflow.com/questions/1588599/sql-server-agent-job-timeout

http://www.postseek.com/meta/92e398aa70cd5e86c5979cd35b7fa736

http://www.mytechmantra.com/LearnSQLServer/Tips-to-Avoid-Account-Lockout-Issues.html

http://databaseadministration.aspcode.net/ppst/63547616526662281693706/package-deployed-in-ssis-2012-catalog-fails-with-timeout-error
Environment reference Id: NULL. Description: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Source: .Net SqlClient Data Provider

http://databaseadministration.aspcode.net/ppst/63547616526662281656636/sql-agent-job-hangs-without-any-errors-or-warnings

Thanks

George

Post by Erland Sommarskog

Post by George Lewycky
We have scheduled job running a console application daily. For some
reason on Sunday's only the scheduler says it ran successfully but no
email confirmation, table entries and the normal processing occurs.
This happens only on a Sunday and for no explained reason. No problem on
the day before or after...
I think this also happened with Daylight Savings adjustment. Has anyone
else encountered this?

Does it happen every Sunday? Or did it only happen this Sunday? And
was this a Sunday when you went over to Daylight Savings where you are?
How is the email confirmation produced? By the console application or
is it supposed to be sent by Agent?
--

[Erland Sommarskog]

Post by George Lewycky
Thanks for replying....
It not EVERY Sunday but up to 3/year and only on Sundays.
I checked the other dates and they didnt coincide with Daylight Savings.
The VB.NET console app produces the email and run the SQL generate GUIDs
and updating other tables.

So we have a problem with a VB .NET application sometimes not
producing an email. It happens to also perform some work in SQL Server,
but I think you are better asking for help in a .NET forum. And I would
expect the people there to see the code.

Post by George Lewycky
One oddity for a quick job with few records on Sunday it took almost two
minutes. Could the DBMS (a timeout?), connection be down and yet the
agent still ran and thought all went ok with the Console app reporting
it back as successful even though no activity occurred??

Since I have no idea what is in the job, I can of course not say anything
at all.

[George Lewycky]

Post by Erland Sommarskog

Post by George Lewycky
Thanks for replying....
It not EVERY Sunday but up to 3/year and only on Sundays.
I checked the other dates and they didnt coincide with Daylight Savings.
The VB.NET console app produces the email and run the SQL generate GUIDs
and updating other tables.

So we have a problem with a VB .NET application sometimes not
producing an email. It happens to also perform some work in SQL Server,
but I think you are better asking for help in a .NET forum. And I would
expect the people there to see the code.

Post by George Lewycky
One oddity for a quick job with few records on Sunday it took almost two
minutes. Could the DBMS (a timeout?), connection be down and yet the
agent still ran and thought all went ok with the Console app reporting
it back as successful even though no activity occurred??

Since I have no idea what is in the job, I can of course not say anything
at all.
--

Thanks again for your advice

Its nothing fancy, just a console app with SQL which pulls serial numbers a day old and generates a text file to be placed for FTP and updates and inserts a few records...

I'm hoping others encountered this or this might do some maintenance done on weekends intermittently

George