v2000, i have a job which runs this each day across 12 different endpoints. (basically, a job that loops thru it 12 times)
Under normal conditions, the output of that is exactly one record. I want/need to pump that into a log table. Having some problems getting around that declaration of the @begin and @end. I have to use that, however, in order to pass the appropriate @start and @stop to the proc.
My output is simple.. just 12 fields... one record.
Any suggestions are appreciated.
declare @begin datetime, @end datetime
set @begin=CONVERT(VARCHAR(50),GETDATE(),101) + ' 00:00' set @end=DATEADD(mi, 1, GETDATE())
exec procedurename @sourceserver='server2',@sourcedb='database2',@destinationserver='server1',@destinationdb='database1',@endpoint='XXXX',@start=@begin,@stop=@end,@flag='Y'