Task Agent down - Alert notification

system · September 28, 2015, 9:16am

Chia: Reports and processes that users run during the day go to the Task Agent as 'Immediate Run Requests' (versus being scheduled) and should be picked up and processed right away. So, long periods of not seeing 'Immediate Run Requests' is a good thing. We have found that when the Task Agent craps out, these requests sit waiting. Therefore our SQL job to look for ones that have been around for longer than 60 seconds.

Calvin: Thanks for the suggestion on SQL Agent. However, we want a little more control of the restart. That is, we want to see what was running so we know what needs to be cleaned up (AR Invoice Post, MRP, etc.).

Thanks,

Bob Beaghan

system · September 25, 2015, 9:59am

<!-- #ygrps-yiv-1830293763 _filtered #ygrps-yiv-1830293763 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1830293763 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1830293763 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-1830293763 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} _filtered #ygrps-yiv-1830293763 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-1830293763 #ygrps-yiv-1830293763 p.ygrps-yiv-1830293763MsoNormal, #ygrps-yiv-1830293763 li.ygrps-yiv-1830293763MsoNormal, #ygrps-yiv-1830293763 div.ygrps-yiv-1830293763MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-1830293763 a:link, #ygrps-yiv-1830293763 span.ygrps-yiv-1830293763MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-1830293763 a:visited, #ygrps-yiv-1830293763 span.ygrps-yiv-1830293763MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-1830293763 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1830293763 code
{
font-family:“Courier New”;}
#ygrps-yiv-1830293763 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-1830293763 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1830293763 span.ygrps-yiv-1830293763HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-1830293763 p.ygrps-yiv-1830293763attach, #ygrps-yiv-1830293763 li.ygrps-yiv-1830293763attach, #ygrps-yiv-1830293763 div.ygrps-yiv-1830293763attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1830293763 p.ygrps-yiv-1830293763bold, #ygrps-yiv-1830293763 li.ygrps-yiv-1830293763bold, #ygrps-yiv-1830293763 div.ygrps-yiv-1830293763bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1830293763 p.ygrps-yiv-1830293763green, #ygrps-yiv-1830293763 li.ygrps-yiv-1830293763green, #ygrps-yiv-1830293763 div.ygrps-yiv-1830293763green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-1830293763 p.ygrps-yiv-1830293763replbq, #ygrps-yiv-1830293763 li.ygrps-yiv-1830293763replbq, #ygrps-yiv-1830293763 div.ygrps-yiv-1830293763replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1830293763 p.ygrps-yiv-1830293763ad, #ygrps-yiv-1830293763 li.ygrps-yiv-1830293763ad, #ygrps-yiv-1830293763 div.ygrps-yiv-1830293763ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1830293763 p.ygrps-yiv-1830293763underline, #ygrps-yiv-1830293763 li.ygrps-yiv-1830293763underline, #ygrps-yiv-1830293763 div.ygrps-yiv-1830293763underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1830293763 span.ygrps-yiv-1830293763yshortcuts
{}
#ygrps-yiv-1830293763 p.ygrps-yiv-1830293763ad1, #ygrps-yiv-1830293763 li.ygrps-yiv-1830293763ad1, #ygrps-yiv-1830293763 div.ygrps-yiv-1830293763ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1830293763 p.ygrps-yiv-1830293763ad2, #ygrps-yiv-1830293763 li.ygrps-yiv-1830293763ad2, #ygrps-yiv-1830293763 div.ygrps-yiv-1830293763ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1830293763 p.ygrps-yiv-1830293763underline1, #ygrps-yiv-1830293763 li.ygrps-yiv-1830293763underline1, #ygrps-yiv-1830293763 div.ygrps-yiv-1830293763underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-1830293763 span.ygrps-yiv-1830293763yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1830293763 span.ygrps-yiv-1830293763yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-1830293763 span.ygrps-yiv-1830293763EmailStyle34
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-1830293763 .ygrps-yiv-1830293763MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-1830293763 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1830293763 div.ygrps-yiv-1830293763WordSection1
{}
#ygrps-yiv-1830293763
_filtered #ygrps-yiv-1830293763 {
}
_filtered #ygrps-yiv-1830293763 {

font-family:Symbol;}
_filtered #ygrps-yiv-1830293763 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-1830293763 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1830293763 {

font-family:Wingdings;}
#ygrps-yiv-1830293763 ol
{margin-bottom:0in;}
#ygrps-yiv-1830293763 ul
{margin-bottom:0in;}
–>

What are some companies doing to alert that the task agent is down and not processing reports or scheduled tasks?Â Sometimes we wonâ€™t know until userâ€™s look in the system monitor and lets us know that their print reports are going straight to the scheduled task.

system · September 25, 2015, 4:54pm

We're running on MS SQL and have a SQL Agent job scheduled to run every minute looking for tasks that are of type 'Immediate Run Requests' and have been queued for over 60 seconds.

select *

from dbo.SysAgentSched sas with (nolock)

join dbo.SysAgentTask sat with (nolock) on ((sas.AgentID = sat.AgentID) and (sas.AgentSchedNum = sat.AgentSchedNum))

where (sas.SchedType = 'Immed')

and (datediff(second, dateadd(second, sat.SubmitTime, sat.SubmitDate), current_timestamp) > 60)

If any records are returned, then send an email via DatabaseMail.

Bob Beaghan

system · September 25, 2015, 5:30pm

There may be long periods where there are no tasks that are the type of â€˜immediate run requestsâ€™, is there another way to handle these situations sooner than later?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, September 25, 2015 3:55 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Task Agent down - Alert notification

We're running on MS SQL and have a SQL Agent job scheduled to run every minute looking for tasks that are of type 'Immediate Run Requests' and have been queued for over 60 seconds.

select *

from dbo.SysAgentSched sas with (nolock)

join dbo.SysAgentTask sat with (nolock) on ((sas.AgentID = sat.AgentID) and (sas.AgentSchedNum = sat.AgentSchedNum))

where (sas.SchedType = 'Immed')

and (datediff(second, dateadd(second, sat.SubmitTime, sat.SubmitDate), current_timestamp) > 60)

If any records are returned, then send an email via DatabaseMail.

Bob Beaghan

[Non-text portions of this message have been removed]

system · September 25, 2015, 5:37pm

You can use port monitoring software, usually when the TaskAgent fails, the port falls out of use because it shuts down, so if you use something that monitors ports, then once 9403(for standard Epicor 9.05) stops responding as being active, the software will send an email.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, September 25, 2015 5:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Task Agent down - Alert notification

There may be long periods where there are no tasks that are the type of â€˜immediate run requestsâ€™, is there another way to handle these situations sooner than later?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]

Sent: Friday, September 25, 2015 3:55 PM

To: vantage@yahoogroups.com

Subject: Re: [Vantage] Task Agent down - Alert notification

We're running on MS SQL and have a SQL Agent job scheduled to run every minute looking for tasks that are of type 'Immediate Run Requests' and have been queued for over 60 seconds.

select *

from dbo.SysAgentSched sas with (nolock)

join dbo.SysAgentTask sat with (nolock) on ((sas.AgentID = sat.AgentID) and (sas.AgentSchedNum = sat.AgentSchedNum))

where (sas.SchedType = 'Immed')

and (datediff(second, dateadd(second, sat.SubmitTime, sat.SubmitDate), current_timestamp) > 60)

If any records are returned, then send an email via DatabaseMail.

Bob Beaghan

[Non-text portions of this message have been removed]

------------------------------------
Posted by: "Chang, Chia" <cchang@...>
------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
------------------------------------

Yahoo Groups Links

system · September 27, 2015, 4:05pm

Bob â€“

The query method works well. The query can be scheduled to execute every 3 minutes on the server.
We suggest having the SQL Agent kick off a process that restarts the Task Agent using a batch file.
This stops the need for an email and just fixes the problem for the users.

HTH

Thank you in advance,
Calvin Dekker
[CB]<http://www.codabears.com/>
630-672-7688 x1484

[Untitled-1] <https://www.facebook.com/CodaBearsInc> [Untitled-2] <http://www.linkedin.com/company/codabears-inc> [Untitled-3] <https://twitter.com/CodaBearsInc> [G+] <http://google.com/+CodaBearsIncRoselle>
[cid:5F7B4A7C-3EB2-41BA-9D90-EB6A55AA1138]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, September 25, 2015 4:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Task Agent down - Alert notification

There may be long periods where there are no tasks that are the type of â€˜immediate run requestsâ€™, is there another way to handle these situations sooner than later?

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Friday, September 25, 2015 3:55 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: Re: [Vantage] Task Agent down - Alert notification

We're running on MS SQL and have a SQL Agent job scheduled to run every minute looking for tasks that are of type 'Immediate Run Requests' and have been queued for over 60 seconds.

select *

from dbo.SysAgentSched sas with (nolock)

join dbo.SysAgentTask sat with (nolock) on ((sas.AgentID = sat.AgentID) and (sas.AgentSchedNum = sat.AgentSchedNum))

where (sas.SchedType = 'Immed')

and (datediff(second, dateadd(second, sat.SubmitTime, sat.SubmitDate), current_timestamp) > 60)

If any records are returned, then send an email via DatabaseMail.

Bob Beaghan

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]