How about creating and scheduling a "bcp out" command saving results of a query into a batch file and then linking the job that runs the bcp on completion execute the created batch file. For example, if your paramets table mytable has columns prog_name, col_a, col_b, col_c the bcp out command may look like
bcp "select 'prog_name ' + col_a + ' ' + col_b + ' ' + col_c' from mytable" queryout c:\jobs\mybatch.bat -T -c For more info see
http://msdn2.microsoft.com/en-us/library/ms162802.aspx : What is the best way to schedule a series of C# executables,
: which have a series of parameters that are updated daily into
: a MS-SQL Db table? : Basically I want to set up some tasks which run sequentially and
: all the parameters for the tasks are stored in a process table. : Will 24x7 do this? I was thinking of writing a Java program which
: used the Process class to execute this...but I figured if 24x7 did this
: then why waste my time. : Thanks
: mike
|
