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!
|
|
Run script at specified time
Posted: 15 Jul 08 7:19 AM
|
Hi guys, I've tried to search for an answer to this but dont really know what to ask for...
I'm looking to run a script at a specified time, say 9.00am. So as soon as the server clock says 9.00am the script runs, simple as that really.
Is this at all possible? If so where would the script run from?
How does an activity turn red once its overdue? Is there a script somewhere that is constantly checking the time and updating activities once they are overdue?
I'm probably being dumb but thought I'd ask anyway, any help is much appreciated!
Oh im using 6.2 btw.
Thanks
Lee |
|
|
|
Re: Run script at specified time
Posted: 15 Jul 08 9:57 AM
|
| If you are running sync you can try to use a sync agent. Go into Administrator and look under "Systems" and then take a look at the Agent tab. Try adding an agent and schedule it for 9:00Am. The next time the sync server runs after 9:00AM the agent script will run. |
|
|
|
Re: Run script at specified time
Posted: 15 Jul 08 10:07 AM
|
You could always write a VBScript that connects to your DB using the SLX OLEDB provider to do what you want, then have it fire off as a scheduled task.
I've had to resort to that for a few things. |
|
|
|
Re: Run script at specified time
Posted: 15 Jul 08 10:23 AM
|
Ian: Well you learn something new everyday... never even knew that tab existed and I thought i'd explored pretty much everywhere!
Thanks alot I'll check it out!
Greg: Where would you tell the system to schedule the task using your method?
Thanks for the replys! |
|
|
|
Re: Run script at specified time
Posted: 15 Jul 08 10:45 AM
|
It run it as a scheduled task from the windows control panel (assuming you are running windows).
I'd have it set to run "CScript c:\scriptfolder\scriptname.vbs" |
|
|
|
Re: Run script at specified time
Posted: 15 Jul 08 10:54 AM
|
Ahhhhh Scheduled Tasks in Windows I see... I was wrongly assuming I'd overlooked a 'Scheduled Tasks' tab/option within saleslogix.
Thanks for you help guys, I'm gonna look into both option now! |
|
|
|
Re: Run script at specified time
Posted: 15 Jul 08 7:19 PM
|
Or schedule the job from within SQL Server (DTS or SSIS) - use a script task & SQL Agent - easier to manage than a scheduled Windows task, IMO.
Phil
|
|
|
|