Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: FaStOnE
  • Content: Threads
  • Order by date
  1. FaStOnE

    Testing "Batch" Status

    Is there a way to test for a job submitted by "msdb.dbo.sp_start_job" for completion? I kick off a Bulk Insert job that can run for 10-30 seconds. But, I need to process the result table in the next step. How can I monitor the job to test for the completed status so that I can...
  2. FaStOnE

    Using Variable File Names

    How do I use a Variable File Name to do (in this instance) a Bulk Insert from? **Sample Code** Declare @Server VarChar( 50) Declare @Path VarChar(150) Declare @File VarChar( 50) Declare @Ext VarChar( 5) Set @FName = @Server + @Path + @File + @Ext Bulk Insert db..Table01 From @Fname...
  3. FaStOnE

    Bulk Insert Issue

    I need to do a Bulk Insert of a comma delimited file into a predefined table. Not a problem under normal situations... but... I have a Generic table with 500 columns defined: ( Col001, Col002, Col003 ... Col500 ) The ASCII data I need to pull from a comma delimited file will have uneven...
  4. FaStOnE

    Importing data in exact order

    I need to import some comma delimited data into a table, BUT I need it to enter in arival order. Currently, I can use or setup the bcp or Bulk Insert and pull the data and it is listed in the Table in random order. What I need is data that is stored in the following format... REC 1 REC 2 REC...
  5. FaStOnE

    Automated Stop/Start of SQL Server

    Is there a way to automate a nightly Stop/Start of the SQL Server? I'd like to schedule this as a nightly process just to "make sure" it cleans itself up. If so, can you show some examples of how to accomplish this? Thanks!! Rick (Remember... 2 wrongs do not make a right! But, 3...
  6. FaStOnE

    How does a scheduled Job disables itself?

    I have a scheduled Job that is set up to run from 8am to 8pm Mon-Fri, with no end date. The job runs a stored procedure and works fine when it runs. Unfortunately, after it completes the daily runs (at 8pm) it disables itself somehow. Thus, not restarting again until I manually force it to an...
  7. FaStOnE

    Display "busy" window while query running in background

    Wasn't sure where to post this, but thought I would start here. I have several JSP pages that I build SQL Queries with for my office. Unfortunately, there are some queries that must be run across a 1 to 20 million record databases. What's the easiest way to have a "Busy" screen show...

Part and Inventory Search

Back
Top