[dba-SQLServer] Running Sprocs using a batch file that is then executed 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
>Technology Commercialization
>Information Systems Administrator
>PH: (509) 375-3758
>FAX: (509) 375-6731
>E-mail:  Kenneth.Stoker at pnl.gov
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=dept/bcomm&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca