Viewing 3 posts - 1 through 3 (of 3 total)
Plenty of solutions already in place and I tried to built something from all:
select next_run_date,next_run_time,
CONVERT(CHAR(8), next_run_date, 112)+
CONVERT(datetime,STUFF(STUFF(RIGHT('000000' + CONVERT(VARCHAR(8), next_run_time), 6), 5, 0, ':'), 3, 0, ':'),108) next_datetime
from dbo.sysjobschedules
But, every...
May 3, 2013 at 7:52 am
Yes the format is same, using pipe separator.
But its dynamic thing, based on table, there will be enabled flag, if its 1 then only pick up those queries to export...
July 30, 2012 at 8:25 am
Yes I think this should work out with BCP Utility
And Yes this is recurring process, with same table from where queries and destination path will be picked up dynamically and...
July 27, 2012 at 6:57 am
Viewing 3 posts - 1 through 3 (of 3 total)