DTS Scheduling Problem (Job Hangs)

Mar 21, 2000

I have created a DTS package and am having problems running it under the SQL Agent scheduler. (This is a test package and copies < 15 records from one table to another table in the same DB.)

We are running SQL Svr 7 + SP1. The server is using mixed security. The package was created using a SQL Server userid (Trusted NT ids do not have correct security to retrieve and execute the package.)

I used Enterprise Manager to schedule the package. I have edited the job to call DTSRun with the correct userid and password.

When I run the job from my desktop, it completes within a few seconds. (I have tried running the same DTSRun command from a command prompt as the one used by the scheduled job and the package completes in under a minute.)

When the job is started by SQL Agent it appears to hang and never complete.
Any ideas??

View 2 Replies


ADVERTISEMENT

Plz Help - EM Hangs

Jun 26, 2001

I posted a message about this yesterday but I have more info..

I have a server (SQL 7.0, sp2) that anywhere I connect to it through EM the EM hangs. I can drill down into the server and even get into the Security drop down but if I hit Databases to drill down or Management etc. It hangs.

I did profiler on this and another server. When I click the + by the Database folder I hang and get
"TSQL:Batch Starting: exec sp_MSdbuseraccess N'db', N'%'"
but never get a "TSQL:BatchCompleted" for that statement. (Where other working servers I do get the set of both start and completed)

Drilling into the Security tab runs the query: exec sp_MSDBUserpriv... etc.) and this one works..

Anyone have any info on: exec sp_MSdbuseraccess N'db', N'%'

I can't find anything in BOL, Microsoft KB, Technet etc.. Please Help as there are certain things I can't do without EM... THANKS!!!

View 1 Replies View Related

Sql 7.0 Install Hangs

Jun 5, 2001

I have been trying all day to install SQL 7.0 on an NT 4.0 SP6a server. It gets to the point where it wants to load MDAC and just goes out to lunch. No errors are generated and the rest of the system does not appear to be affected. However, the only way to end the install is to end task it. Has anyone run into this?

View 1 Replies View Related

How To Know Automatically If The Job Hangs?

Sep 28, 2001

Some of my jobs hang at FTP step for several hours until some one kills the FTP (it's a perl process) on the box. Is there a way to find how much time a particular step of the job is executing? and know it by somehow if it's hanging at that step?? If we know this,I want to kill the perl process(FTP) on the box in an automated way whenever the job hangs! Any ideas welcome!! Thanks. :-)

Di

View 3 Replies View Related

DTS Hangs - URGENT

Oct 25, 2000

Hi all - I'm having a problem with a dts job that I haven't run across before. The function of the job itself is pretty basic just moving data into a sql table using a few lookups and mappings. The job starts fine and gets to a status of 5000 records processed and just sits there. It's doesn't go into a 'not responding state' nor does it produce any error information in the error file I set up. Anyone have any thoughts on what might be happening? How to identify the specific record it may be hanging on? Help!! - this one is driving me nuts.

View 4 Replies View Related

DTS Hangs - URGENT

Dec 4, 2000

I'm running a pretty simply DTS just to pump some data into a table. Nothing fancy just a couple lookups and a couple columns being copied over. I get to 5000 records processed and the DTS just spins its wheels. It does not go into a 'not responding' state. There are no indexes on the table and the db size is plenty big so it is not reindexing or resizing the db at this point. Any ideas on how I can debug this one would be greatly appreciated.

Thanks

View 2 Replies View Related

DTS Always Hangs On Finish

Sep 28, 2000

I am having a problem importing data into SQL 7 from any type of source. I go through the whole import process no problem. When I click the finish button to start the import, nothing at all happens. Enterprise Manager and the DTS just hang and I must use crtl+alt+delete to end the program. Can anyone give me any suggestions as to what might be happening. Big Thanks in advance, I've been working on this for days.

glevi

View 3 Replies View Related

Shrinkfile Hangs Up

Apr 19, 2000

Anyone else had this problem ?

I've run dbcc check commands on a 5Gig database which has 2 Gig of unallocated space, with no problems with the tables or database.
However when i try to run dbcc shrinkfile ( on the DATA file ) from Query Analyser the command just runs indefinitely with no response.

Duncan

PS SQL 7 sp 2

View 2 Replies View Related

DTS Package Hangs

Aug 28, 2000

I am having problems of my DTS package hanging when run through the sql server agent through a scheduled job. If I execute the job manually it runs fine? If I run the package manually it runs fine? Of course there is no way to actually tell what is being hung? Any ideas?

Thanks David

View 2 Replies View Related

Restore Hangs

Oct 15, 2002

Hi everyone, I had to do a restore of a database from tape. I have the tape set to eject when it's complete, the tape ejects and the dialog box looks like the restore finishes fine. But when I look at the database after the restore it is still in the loading phase. So the restore never really took or looks like it hangs. Do you guys know why or how to fix this problem? Thanks in advance.

Stink!

View 1 Replies View Related

SQL Server Hangs

Feb 12, 1999

My client is using SQL Server 6.5 on NT 4.0. They have recently began to have their SQL server session freeze intermittently.
I have determined that only users that are accessing one particular database are freezing which leads me to a locking problem.
What is the best way to determine the locking problem (i.e. event logs, sp_lock, ....)?

View 2 Replies View Related

IIS 4 Hangs To SQL 2000

Oct 22, 2004

Hello everyone,

I've done some searching, asking of friends, and searching every log file and event file I can think of. So now I'm coming here.

Recently I moved some of our databases from an NT4 box running SQL 7 to an Advanced 2000 box running SQL 2000. The web server is still on an NT4 box. It seems that about three times a day or so ASP type files will hang on the webserver. This server hosts different sites and all ASP type files will stop even if some of them hit the old SQL7 server.

Right now I moved the web server back to looking at the SQL 7 machine and things are going fine.

Can anyone offer me a direction to start looking? Why is it working fine to the old stuff but not the new stuff? Is there an issue with NT4 with its IIS trying to talk to an Advanced 2000 with its SQL2000?

Thank you in advance for any help.

View 2 Replies View Related

CTE Update Hangs

May 30, 2008

I've written a recursive CTE to update a table's heirarchy data with a lineage that the CTE builds. This works and executes over 80,000 records on my local test environment in about 45 seconds. However when I try to execute it from a "production" environment, it hangs and never completes the update (well at least it's taking longer than 5 minutes and I'm too impatient to wait). The CTE itself still runs fine and returns data if I do a Select *, but not when I run the update. Here's my CTE, any ideas? Is there anything in database settings that would disallow this query update? or field requirements?

WITH MyLineage (ID, Lineage, ParentID)
AS (SELECT ID, CAST('.'+ convert(nvarchar(max), ID) +'.' AS nVarchar(max)) as Lin, ParentID FROM Equipment WHERE OrgID=2 AND ParentID IS NULL
UNION ALL
SELECT E.ID, CAST(L.Lineage+ convert(nvarchar(max),E.ID)+'.' AS nVarchar(max)) AS Lin, E.ParentID FROM Equipment E INNER JOIN MyLineage L ON L.ID=E.ParentID WHERE L.ID=E.ParentID)
UPDATE E SET E.Lineage=L.Lineage FROM Equipment E INNER JOIN MyLineage L ON E.ID=L.ID

If I try to do the update like this:

UPDATE Equipment SET Lineage=(SELECT Lineage FROM MyLineage WHERE MyLineage.ID=Equipment.ID)

it will hang in my local test environment as well. It seems like the other sql 2005 server instance is converting the join update into a nested select update, or something. I don't know what's going on, help?

View 9 Replies View Related

Server Hangs

May 15, 2007

Hi ppl

I have a DTS that is loading 6 text files into respective tables. Before loading this files the tables are emptied using SQL tasks with the following code:
DELETE
FROM Table1
WHERE (OMC=?)

OMC is a PK from table1 and ? is a parameter within the DTS.
Occasionally the system hangs executing these delete statements for one of the tables (not always the same!)
I’m forced to reboot and then DB goes trough a recovery process.


Any idea what might be wrong?

Thanks in advance

View 1 Replies View Related

SQL 7 SP 4 Installation Hangs

Jul 23, 2005

Hi,Currently it is running on SQL 7.00.623 on Winnt 4.0+SP5.Now i want to upgrade this with SP 4.As i follow the installation procedure according to MicrosoftSQL7SP4 readme help, It hangs during the installation of Mdac_typ.exe.Don't know where and whats went wrong with the procedure.I've tried 3-4 times to install it but the same problem raises. Pleasesome body assist me how to complete this installation.Thanks in advanceIvar

View 2 Replies View Related

SQL Agent Hangs

Mar 7, 2006

I have an SSIS .dtsx package that will run fine during debugging, however, when I run it as a job under the SQL Agent the job won't start.

To be more specific, the Agent will load the package, ensure that it passes validation (which it does), then sit there without starting the rest of the package.

The job will run under the "executing" status until I stop it manually.

Does anyone have any idea why it might be doing this?

View 15 Replies View Related

SSE Occasional Hangs

Oct 17, 2006

I've installed SSE2005 (with SP1 and the hotfix rollup) on a Small Business Server 2003 SP1, and 90% of the time, all is well.

SSE is running two user databases; one for an ASP web-based application, and one for a desktop application. Occasionally, pretty much everything for both apps hangs for a number of seconds (variable, but probably about 10-30 seconds at a time). During the hangs, even using Management Studio Express becomes impossible, and Activity Monitor just times out, so I can't see what's happening. SSE's Errorlog and server Event Logs show nothing unusual.

The hangs tend to come in batches, on-and-off for an hour or so, after which the problem clears and it's service as usual.

Does anyone have any ideas what the problem might be, or at least how to start tracking it down?

View 1 Replies View Related

SSIS Pkg Hangs From Job

Nov 28, 2007

Hi,

I have a package that runs just fine from BIDS. There are no message boxes in any scripts, or prompts of any kind.

However, when I attempt to the exact same package from a job, it just hangs forever.

Is there an obvious explanation for this?

Thanks

View 11 Replies View Related

SQL Server Hangs Once In A While

May 7, 2007

I have a problem where a SQL 2005 server in the morning will deny all connections do to a time out error. Sytem has 4 CPU's in it and sqlservr.exe is utilizing 85% of all CPU's. If I run filemon it does not show activity to any of the SQL databases. I get a login timeout message when I try to connect via the enterprise manager or from a command prompt, even if I bump the timeout delay to 5 minutes. If I restart the SQL Server services all is fine for a few days.

View 4 Replies View Related

SQL Server Hangs

Jun 8, 2007

On random occasions, our SQL Server instance will just hang and the users will not be able to use the application until we restart the SQL Server 2005 Service. Anyone have any ideas what we might do to figure out what is going on? The server hung up at 8:00 AM this morning. There was nothing after our midnight backup in the log until we rebooted the server at 8:05 AM.



Any suggestions would be greatly appreciated. Thanks! - Eric-

View 1 Replies View Related

UA Hangs When It Reaches 28%

Sep 28, 2007



Hi,


Im trying to upgrade the PUBS DB from SQL 2000 to SQL 2005 using UA, the analysis starts well and progress and hangs at 28% for about 1 hours, what could be the reason, can any one help me?


Thanks in advance
Sakthi

View 1 Replies View Related

Pre-execute Hangs At 50%

Aug 6, 2007



Hello,

I did a search and found no answers. I have a simple project; one data flow task reading from one DB2 tabel and writing to another. My OLEDB source is a sql command that returns 97,000 rows and my OLEDB destination's data access mode is "table or view".

For my OLEDB source SQL command, I run it through the "build query" panel and I get all 97,000 rows back within 90 seconds everytime.

I don't know what is so different since I currently do SQL commands that bring back 2.5 million rows from DB2 with no effort in SSIS. I even took my data flow task and placed into a known good solution - but still hangs at 50% forever. I tried attaching to SSIS server and executing through there, again no luck. Still hung!

Any ideas? Thanks.

View 8 Replies View Related

Job Scheduling In Sql 7.0

May 30, 2002

I have set a job to run hourly between 8 am and 8 pm. I mark the schedule as enabled and mark the job as enabled. It will run for that day and then the enable check on the schedule clears out. I have several other jobs that run without this problem. Has anyone heard of this before and can this be effectively monitored?

thanks, mary

View 3 Replies View Related

Scheduling

Oct 16, 2001

Hi,
Can anybody give me the steps to schedule Database backup and restores in 7.0?
I can do the backup and restores of the database without scheduling. I dont know how to do with scheduling.

Thanks in advnace.

View 1 Replies View Related

Scheduling Of Job

Feb 15, 2001

I've created a task which monitors the server, I want it to run every 30 sec.
But the scheduler in job allows to run at the most only 1 min. Is it the way to make it 30 sec?

Thanks.

Qinglee

View 2 Replies View Related

Scheduling A DTS Job

Sep 13, 2000

Does anyone know how to schedule a DTS job to collect data from another database?

cheers!

View 1 Replies View Related

Job Scheduling

Sep 20, 2000

Can I use SQL Server Agent schedule to start my.exe?
I am not sure in command that I have to place in "Edit Job Steps" DialogBox.
It's not working just with path.

View 1 Replies View Related

DTS Scheduling

Aug 11, 1999

Hello all,
I am trying to schedule DTS package. Seems like I have two options
1. Save DTS package as a File and Run it using dtsrun function
2. Save DTS package on server and use scheduling wizard

If I use method #1 it works fine but you have ti create job, schedule it
and yada, yada, yada.....
Method #2 seems mach more simple but then I use it it does nothind.

Am I missing something?

Thank you an advance.

Boris

View 1 Replies View Related

DTS Scheduling

Jul 22, 1999

I'm having a little trouble getting a DTS package to run as a scheduled event. I have created the same one(an export to Access db on the same computer) as a local package and a repository package. Both will run normally when I start them manually from the DTS screen, but they will not run from the scheduler. It seems like this might be some kind of permissions problem, but it could easily be something else, since I've never used DTS before.

Thanks

View 1 Replies View Related

DTS Scheduling

Feb 21, 2001

I created a DTS to transfer two tables from one server to another and set up a schedule to run once everyday. I could not get it to run. I got this warning message from evetlog:
SQL Server Scheduled Job 'Forum' (0x0E0AA96BB9A1654C94AA12CC8B854BC8) - Status: Failed - Invoked on: 2/21/2001 4:00:00 PM - Message: The job failed. The Job was invoked by Schedule 1 (Forum). The last step to run was step 1 (Forum).
But when I execute it manually, it run successfully.

I am using MS SQL 7.0
Your help is much appreciated.

View 1 Replies View Related

Job Scheduling

May 19, 2002

i'm very new to sql server and stuff... so i'm lost here.
i'm using the job scheduling wizard and i'm getting a couple of errors. first of all i need this vbscript to run weekly... do i need to translate it to tsql, or can i just paste this into the job scheduler thing?

-----------------------------------------------------------
dim strSQL, oConn, objRS
const adOpenDynamic = 2
const adLockOptimistic = 3
Set oConn = Server.CreateObject("ADODB.connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
oConn = "my conn string with secure info you cant see :)"
strSQL = "SELECT BattleRD FROM BattleList"
objRS.Open strSQL, oConn, adOpenDynamic, adLockOptimistic
objRS.MoveFirst
While Not objRS.EOF
objRS("BattleRD")=objRS("BattleRD") + 1
objRS.Update
objRS.MoveNext
Wend
objRS.Close
Set objRS = Nothing
-----------------------------------------------------------

here are my errors in the job scheduler after selecting the dates...

error 229: execute permission denied on object 'sp_help_operator', database 'msdb', owner 'dbo'

and...

error 229: execute permission denied on object 'sp_help_targetserver', database 'msdb', owner 'dbo'

what am i doing wrong / what do i need to do?

thanks

View 1 Replies View Related

Job Scheduling

Jan 29, 2004

Hi,

I have two jobs scheduled on the Agent. Each job has ten steps. The next step is executed only if the previous suceeds.

I want Job 2 to execute only if Job 1 suceeds. How do I schedule that?

I was thinking that I can have the ten steps of Job 2 as steps (11 to 20) of Job 1 with each step executing after the previous one succeeds. If I do that then I can get rid of Job 2.

Let me know what approach you would advise.

Thanks

View 3 Replies View Related

Job Scheduling

Jun 24, 2008

I am trying to schedule a simple job to run a stored procedure in my database. The stored procedure runs perfectly when I do so manually, however when I ask a job to run it, it gives me the following error:

Access to the remote server is denied because the current security context is not trusted [SQLSTATE 42000](Error 15274).

The stored procedure does create a linked server (to an ORACLE database) and executes some commands across it. I've tried doing the link server creation as a separate step in the job and it executes that just fine so it has no issues creating the server, it just dies when it tries to use it. The job owner is the same user I've been using the execute the procedure manually. I also run the procedure step as that same user. But I still have this problem. Someone please help me!!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved