Stoker, Kenneth E
Kenneth.Stoker at pnl.gov
Mon Jan 12 17:18:52 CST 2004
I have been looking everything I can find on osql, but I cannot find anything about using a dsn. There are switches for supplying a username and password, but not a dsn. Is it possible to supply a dsn instead? What would the switch be? 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: Francisco H Tapia [mailto:my.lists at verizon.net] Sent: Monday, January 12, 2004 2:25 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Running Sprocs using a batch file that isthenexecuted 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 >> >> > > > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com