Stoker, Kenneth E
Kenneth.Stoker at pnl.gov
Mon Jan 12 16:08:28 CST 2004
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 >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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com