8/27/2025 2:35:03 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Calling an Agent from Stored procedure
Posted: 27 Oct 08 11:03 AM
|
sql 2000
SLX v6.2
We have a stored procedure from another sQL server that dumps data into a temp table in our SalesLogix db. I then have an agent that runs and takes that data and does inserts, modifications, and deletes. My question is this....is there some way that we can call my agent/program from inside this stored procedure that runs on the other SQL server? they want to do this because at any moment they may have data that needs to get into SLX...unless i schedule my agent to run multiple times a day they would rather be able to kick off the agent themselves in this stored procedure so there would be no lag time.....we do have remotes in case that may factor into the answer....
John |
|
|
|
Re: Calling an Agent from Stored procedure
Posted: 28 Oct 08 1:34 AM
|
The fact that you have remotes is a big factor - it means that whatever you do needs to sync out. So you need to use the SLX OLEDB provider when doing the updates.
Now I haven't done this, but I believe that the Agent Runner can be called from the command line? If so, I am pretty sure that you could get your SP on the other server to execute it - given appropriate domain access, of course. Quite tasty and might take a bit of R&D, but should be achievable.
Phil |
|
|
|
Re: Calling an Agent from Stored procedure
Posted: 28 Oct 08 7:33 AM
|
You pretty much have to have something polling the database looking for something to do that can then launch the action.
This is a classic KnowledgeSync / TaskCentre kind of thing.
HTH
ws |
|
|
|
Re: Calling an Agent from Stored procedure
Posted: 28 Oct 08 9:16 AM
|
John, as Walter suggested, TaskCentre can definitely do this, and as Phil said, TC can do it so the updates are all sync aware.
The principle is this. Using a schedule, you will be able to invoke the stored proc in the foreign DB to populate your temp table in SLX. You can then query that table and do the updates. At the moment, the updates would need to be scripted (but that's not too hard). But soon (in a matter of weeks) you'll be able to do it codelessly.
Contact me off-line and I'll explain more.
Paul |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|