Re: Scheduled LONG queries

Kurt Schafer ( (no email) )
Fri, 13 Feb 1998 15:22:30 -0500

Could you elaborate a little ? For example, Consolidation is a stored
procedure in the database now. How would I call this from the Scheduler ?

Thanks.

- Kurt

-----Original Message-----
From: Graeme Slogrove <graeme@fdd.net>
To: emerald@emerald.iea.com <emerald@emerald.iea.com>
Date: Friday, February 13, 1998 3:06 PM
Subject: Re: Scheduled LONG queries

>
>> As we evolve our Emerald installation, we have started to require
>> increasingly more complex TSQL statements to be run on a scheduled
>basis.
>> The 256 character limit is starting to cause problems.
>
>Try rather writing these as stored procedures. Them simply call the SP
>from the Task Manager, hoping of course that you haven't named your
>task with a name of more than 256 characters ;)
>
>Cheers!
> Graeme
>
>
>----
>Posted by WebMail
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>