Search results for query: *

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...

Hey guys... have an addendum to this question. After I get the job started (Submitted to "batch") .. is there a way to test and see if it has completed before it continues with the next statement in the Stored Procedure? Rick

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...

Thanks guys... that actually has done what I need it to do! Your help is much appreciated! Rick

OK, please pardon the ignorance here. How are you implementing(Creating) the Job(ImportJob1) to run the DTS package? I guess I'm missing a step here that's not clicking. Sorry! I can create the Procedure that is called to start the job, but the link from there to the actual job is confusing me.

Yes.. I have imported the data into the Table via the DTS package and that actually works. It's the BULK INSERT that craps out with truncation errors. Unfortunately, I need to automate this ( call it as a Stored Procedure ) from a web based Intranet page. Rick

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...

Terry, Thanks for the info. The import data that I need to bring in does NOT have a column that I can specify an index order on. So, I can't index on anything specific. I have to read the original data in the CSV file in the order it already exists. I just find that it would be easier to...

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...

Thanks for the response... I agree with you... but I'm having some issues with an associated TomCat job working with our intranet. Seems as though I'm getting a memory leak somewhere that eventually affects the SQL Server. I honestly want to schedule a RESTART on the Server, but am trying to...

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...

Here is the Script of the Stored Procedure. It's pretty much straight forward. Set NoCount ON -- Build temp table to hold Inbound Data Drop Table EDI..TmpInbound Create Table EDI..TmpInbound ( TmpInData Char(120) Null ) -- Go get whatever is in our Mailbox at MISG Exec...

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...

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...