More details in System Agent Maintenance

Yahoo Archive
1
When I do that, I get the Business Activity Query Export process screen, but all the fields are blank. I cannot see the BAQ that is being exported.

I did work on this a bit, though, and created a BAQ that gives me the needed info. In the BAQ, I linked SysAgentSched, SysAgentTask, and SysAgentTaskParam, and limited the results returned to rows where SysAgentTaskParam.ParamName equals “QueryID”. I display the fields SysAgentSched.SchedDesc, SysAgentTask.AgentSchedNum, SysAgentTask.AgentTaskNum, and SysAgentTaskParam.ParamCharacter. The last field is the one that contains the name of the BAQ. This BAQ only returns tasks that are BAQ exports.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Tuesday, October 19, 2010 10:01 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] More details in System Agent Maintenance



Highlight the task in the tree view on the left, then select Actions/View Task
Parameters from the drop down menu. This will show you the query information.

________________________________
From: Thomas Rose <t.rose@...<mailto:t.rose%40electricmirror.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Tue, October 19, 2010 10:15:25 AM
Subject: [Vantage] More details in System Agent Maintenance


v. 8.03.403

I have a number of BAQ exports scheduled to run automatically. Now, I need to
reschedule some of those. When I go into system agent maintenance and look at
the tasks, the only thing I see is a list where a bunch of the tasks are
described as Dynamic Query Export. That is lovely, but what I really need is to
know exactly which query is being exported as part of which task. Is there a way
to figure that out?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

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

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



[Non-text portions of this message have been removed]
2
v. 8.03.403

I have a number of BAQ exports scheduled to run automatically. Now, I need to reschedule some of those. When I go into system agent maintenance and look at the tasks, the only thing I see is a list where a bunch of the tasks are described as Dynamic Query Export. That is lovely, but what I really need is to know exactly which query is being exported as part of which task. Is there a way to figure that out?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>



[Non-text portions of this message have been removed]
3
Highlight the task in the tree view on the left, then select Actions/View TaskÂ
Parameters from the drop down menu. This will show you the query information.




________________________________
From: Thomas Rose <t.rose@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Tue, October 19, 2010 10:15:25 AM
Subject: [Vantage] More details in System Agent Maintenance

Â
v. 8.03.403

I have a number of BAQ exports scheduled to run automatically. Now, I need to
reschedule some of those. When I go into system agent maintenance and look at
the tasks, the only thing I see is a list where a bunch of the tasks are
described as Dynamic Query Export. That is lovely, but what I really need is to
know exactly which query is being exported as part of which task. Is there a way
to figure that out?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

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







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