[dba-SQLServer] Running Sprocs using a batch file that is thenexecuted in aNetwork Job Scheduler

i hear ya, it can be done using osql, check BOL for syntax



-- 
-Francisco


Stoker, Kenneth E wrote:

>I understand where you are coming from, but the powers that be have
>stated that we need to use the network scheduler versus setting up a SQL
>Server Agent Job.  There are also some external items that need to be
>part of the job.
>
>
>Ken Stoker
>Technology Commercialization
>Information Systems Administrator
>PH: (509) 375-3758
>FAX: (509) 375-6731
>E-mail:  Kenneth.Stoker at pnl.gov 
>
>
>-----Original Message-----
>From: Billy Pang [mailto:tuxedo_man at hotmail.com] 
>Sent: Monday, January 12, 2004 1:18 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer] Running Sprocs using a batch file that is
>thenexecuted in aNetwork Job Scheduler
>
>
>Not sure if this helps but would you consider using the SQL Server Agent
>to 
>schedule and execute the stored procedure?  The interface to create a
>SQL 
>Server Agent Job is quite straightforward and it can write entries into
>the 
>Event Log upon successful/failure.
>
>
>  
>
>>From: "Stoker, Kenneth E" <Kenneth.Stoker at pnl.gov>
>>Reply-To: dba-sqlserver at databaseadvisors.com
>>To: dba-SQLServer at databaseadvisors.com
>>Subject: [dba-SQLServer] Running Sprocs using a batch file that is then
>>executed in aNetwork Job Scheduler
>>Date: Mon, 12 Jan 2004 13:04:01 -0800
>>
>>Everyone,
>>
>>I have been asked to build a batchrun script that will be run by a 
>>network scheduler to execute a couple of stored procedures.  Can any of
>>    
>>
>
>  
>
>>you give me some advice on or point me to some resources on proper 
>>construction of such a script.  I have built very simple batchrun 
>>scripts in the past but have not done one like this.
>>
>>Thank you.
>>
>>Ken Stoker
>>    
>>
>
>  
>