SQL 6.5 Non-scheduled Tasks Dumping To NULL Device
Jun 13, 2000
I have some "phantom" tasks running, specifically, DB dumps to a NULL Pipe device and they are not scheduled!!! These do not show up in the SYSTASKS table, where can I look to possibly find these un-scheduled dumps? Thank you....
View 1 Replies
ADVERTISEMENT
Sep 15, 1999
If I have 2 scheduled tasks set for the same time (perhaps accidentally), will the
SQL Executive start 1 and queue the other one until the first is complete and
then run the 2nd task? Or will they both be started simultaneously?
Thanks!
Toni Eibner
View 2 Replies
View Related
Feb 12, 1999
I have been running the following production job successfully for a long time.
It now fails, and the Task History Last Error Message displays 'No Message'.
The log file ( C:MSSQLLOGMaint_TombV50.txt) shows it ran successfully,
with a Return Code 0.
SQLMAINT.EXE -D TombV50 -RebldIdx 10
-CkDB -CkAl -CkTxtAl -CkCat
-UpdSts -Rpt C:MSSQLLOGMaint_TombV50.txt
It looks like SQL Executive burps for some reason.
Any ideas, comments, suggestions?
Thanks,
sb
View 1 Replies
View Related
Jun 23, 1999
To all,
If I have a scheduled tasks that is owned by 'sa', how can I assign permissions to allow another user, even the database dbo, to register the SQL server and view the scheduled tasks?
Thanks in Advance,
Ed Molinari
View 1 Replies
View Related
Mar 6, 2007
Is it possible to schedule tasks in SQL Express, for example a database backup, or to periodically execute a stored procedure?
View 3 Replies
View Related
Feb 7, 2008
Hi,
I am using Windows 2000 and created around 15 scheduled tasks. My scheduled tasks supposed to run every morning. I have to set password to first scheduled tasks every morning; otherwise none of the scheduled tasks works. As soon as i put password in the scheduled tasks, other tasks work fine.
Any ideas how to save password to schedule task?
Thanks in advance..
View 2 Replies
View Related
Sep 18, 2000
Hello:
1) Is there a way to call a second task 'upon completion' of the first one. Or would I need to place the code of the second task in one task?
(This is v6.5) I guess the main purpose is to avoid conflict & see if one fails, the other may succeed, etc. I generally like to keep diff tasks separate, but one is dependent upon the completion of the other.
2) I want to restore a db, upon completion of the backup of another db. They are on separate servers, but i know i can use remote sp's.
Any advice, help, code, scripts, etc, would be appreciated. Thank you.
View 1 Replies
View Related
Mar 23, 2001
Apologies if this has already been covered, but I can't find any information.
What is the easiest way to move a batch of scheduled tasks from one server/network to another? Can you script them up somehow and then reapply the script to the new location?
Any advice would be much appreciated.
View 1 Replies
View Related
Jan 19, 1999
I'm running SQL Server 6.5 and have schedules a number of tasks to run overnight. This has generally been successful; even when the tasks have failed, it's been because of a lack of data in a feeder database system.
My problem is that when I try to run the tasks manually, I get a message saying that they can't be run because SQL Executive is not running on the server. Now, this ain't true. The little gizmos show green in the server manager, and if I right click on SQL Executive, 'Start' is disabled and 'Stop' is enabled.
Am I missing something here? Does anyone have any clues or suggestions?
Thanks.
View 2 Replies
View Related
Nov 2, 1998
Hey how are you.
I'm going crazy with EM's Sheduled Tasks.
I've setup couple of backups and weekly maintenance plans from EM.
After couple of days I viewed sheduled tasks from EM toolbar
and found that all the tasks have not executed as I have scheduled.
the task history does not show any history at all.
Clicking refresh does not do any good either.
However if i right click on the database and choose restore i see all the backups
that i have scheduled.
Is this a bug?
Can someone tell me what's wrong???
THANKS IN ADVANCE
View 1 Replies
View Related
Nov 7, 2000
We are running SQL 6.5 sp5a. There have been a number of instances recently where some scheduled tasks don't complete. I can't even cancel them. The only way to stop them is to stop and start the Executive service.
Anyone come across this before and know what the problem is?
View 1 Replies
View Related
Oct 15, 2001
Hi,
All the maintanance jobs scheduled for weekend are still running after 66 hours.
1. transaction log backup
2. integrity check
3. complete backup
4. optimization job
I stopped the jobs from scheduled task lists, I can still see them running through current activity window.
Is it ok to kill them? Or how I can stop them?
Thanks,
Ann
View 1 Replies
View Related
Oct 14, 2005
Is anyone aware of a way of adding scheduled tasks to MSDE?
Obviously in SQL Server you'd use the Enterprise Manager to do that, but I don't believe it is possible to get Enterprise Manager seperately from SQL Server.
Any ideas on that would be great
View 1 Replies
View Related
Jan 22, 2008
What are peoples opinions on using SSIS as a "central repository" and replacement for all scheduled tasks. Example, we have a bunch of servers which we have installed services which we have written. Currently we have scheduled tasks on each machine to stop and start the services. One of my collegues is using SSIS to run a system which runs tasks on multiple machines by remotely running programs on other machines via scheduled tasks and then collects the data and puts it into a database.
He's now pitching the idea that we remove the scheduled tasks on each machine and start and stop our services via SSIS so that it's centralized. In addition, we can also check for holidays in our database before starting services. Since it doesn't seem like SSIS was meant for this type of use, I'm weary of using the tool to do something it wasn't intended for.
Any opinions? I'm also worried that the learnnig curve for everyone is going to be too high.
View 11 Replies
View Related
Sep 7, 2006
Hi Guys
I googled this an I got wonderful resul... no, no I didnt.
Could someone please provide a link or a step by step guide on how to schedule the running of SP's that will then send the results to an email address.
Thanks! This will be VERY useful!
~Coin
View 3 Replies
View Related
Feb 8, 2000
I recently changed the SA password on my SQL Server 6.5 installation and discovered that this had caused the Scheduled CmdExec Tasks (defined in SQL Executive) to fail with:
"Process Exit Code 1. Microsoft (R) SQLMaint Utility, Version 6.50.240 Copyright (C) Microsoft Corporation, 1995 - 1996 [Microsoft SQL-DMO] Error 4002: [SQL Server] Login failed"
Changing the password back to the original resolves the problem, but is a less than satisfactory solution.
Any advice on how I can change the SA password and allow CmdExec tasks to continue running would be gratefully appreciated.
View 1 Replies
View Related
Jun 2, 1999
Good morning,
I have a strange problem with a scheduled task failing with the following:
"Unable to send completion notification email to operator with email name '' for task 2780, 'Scheduled Update'"
This job is the same across several servers and the job runs on the other servers. This is a bit frustrating... I cannot seem to find the difference that is causing the problem.
The funny thing is that I am not using SQLMail or anything to notify anyone regardless if the job succeeds or fails.
Any pointers?
Thanks much,
Don
View 2 Replies
View Related
Apr 22, 1999
I schedule dbcc checkdb command in the SQL schedule task program at 3:00am. It ran successfully but since it ran as a schedule task, I don't know where to find the results. Can anyone help?
Thanks in advance for any help.
Wing
View 6 Replies
View Related
Jun 14, 2006
Hi, all here,
Would please any expert here give me any guidance about what Data Mining tasks can be automated and scheduled via Integration Services Packages? Also, If we automated the tasks, can we also automatically save the results of the tasks somewhere? Like if we automate assessing the accuracy of a mining model, then we wanna know the mining model accuracy later, therefore, we need to save all these results from the automated actions. Is it possible to realize this?
Thanks a lot in advance for any guidance and help for this.
With best regards,
Yours sincerely,
View 3 Replies
View Related
Nov 17, 1998
I have a database in development in SQL Server 6.5 that needs to be occasionally deleted and rebuilt from a script when table structures are changed. I found that when very complex queries were performed, the 2 MB default size of tempdb filled up and returned errors, so I went to the Enterprise Manager to expand tempdb, learned that I had to first expand a device to expand tempdb into, and foolishly chose to expand tempdb into the same device space used by my application, instead of into one of the system databases. Now when I try to delete the device in preparation for its rebuild, the Enterprise Manager responds with an error message saying the device can't be deleted because it contains system tables. Is there any way to get the expanded portion of tempdb out of my application device so that the device can be deleted, without reinstalling SQL Server?
View 1 Replies
View Related
Jun 19, 2006
Basically I've been using Visual Studio 2005 for a few weeks now moving a Pocket PC project from 2003 to 2005. When I hit the Start Debugging Button every time until today the project would rebuild and deploy to my pocket PC allowing me to debug etc but now I get
The remote connection to the device has been lost.
Please verify the device conection and restart debugging.
I used to get this problem in VS2003 sometimes and just like the numerous posts on different sites that I've looked at the problem eventually goes away and I'm none the wiser. One guy said that he found that if he went to bed the problem was resolved when he came back!
My PDA running Windows 2003 2nd Edition is directly connected to my PC via a USB port. I've rebooted my PC and done a soft reset on the PDA but it didn't help. I'm using ActiveSync 4.1.
Does anyone know how to resolve this problem?
View 54 Replies
View Related
Apr 14, 2006
Hi to All
when i m trying to execute following code
backup database web
to disk = 'c:inetpubwwwrootackupmybakup.bak'
with format
I m Getting Error like :
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'c:inetpubwwwrootackupmybakup.bak'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
This error is Generated only when i m trying to access folders within "wwwroot" but not in any other folders , even command runs success fully for "wwwroot" folder . !!
but not for any subfolders of wwwroot.
Can Any One Help Me ??
View 6 Replies
View Related
Jul 13, 2007
Does anyone have a code snippet for dumping the actual sql a command would be running?
View 3 Replies
View Related
Nov 7, 2007
My site is hosted with 1and1. They tell me I need to dump my SQL database before uploading it to their site. I have never done this before. I have looked in the online help and have asked them for help, but nothing seems to work. I've tried queries like the following:DUMP DATABASE dbname TO DISK = 'C:folderfilename'It tells me it doesn't recognize "dbname", which is the name of the MDF file (without the ".mdf" extension). So I'm not sure what I should be using for database name.I'm using Visual Studio 2005 Professional. Can someone help me with dumping my database? Thanks!
View 1 Replies
View Related
Mar 20, 2006
Hi, is there a software that can dump the SQL result into a file or to another database? I am using the MSSQL Server and I am accessing it remotely. Is there a program where I can issue an SQL statement and then I can dump the result into a file (in SQL inserts or just plain CSV).
Is there a free version?
Thanks!
View 2 Replies
View Related
Mar 2, 2007
Hey Guys,
I do alot of development on my personal machine and have quite few databases in SQL Server. My PC is very prone to crashing :-p so Im writing a custom batch script to backup up all my data. How can I backup my SQL Server databses into a text file. I dont want to use the BAK file. In MYSQL this is a relatively simple process where i just have to use the mysqldump utility which scripts 'all' my databases (structure and data). Can I do the same thing in SQL Server? Please tell me a way. Its going to save me a lot of trouble.
Thanks in advance guys.
View 6 Replies
View Related
Jul 20, 2005
Hi - is it possible to dump the query text of every query runagainst a particular database, or all databases, in an SQL Server2000 installation? We've an issue whereby a 3rd. party applicationrunning queries over ODBC sometimes claims that gobbledegook isreturned, and it would be very useful to identify the query that'sbeing claimed is the problem. I suspect that it's an applicationissue rather than a SQL Server one.__________________________________________________ ___________Are you Catholic ?http://www.CatholicEmail.com100s of FREE email addresses --->http://www.UltimateEmail.comSend an Online Greeting Card http://www.UltimateEcards.com
View 1 Replies
View Related
Jul 18, 2000
Does anyone know how I can dump the transaction log to a file
so I can read it?
Thanks,
Dianne
View 4 Replies
View Related
Oct 3, 2000
Using SQL version 6.5, I'm trying to dump our primary database to a backup server
with the following command:
DUMP DATABASE TMSEPRD TO Backup_Server WITH STATS = 10, NOINIT, NOSKIP
I created a backup device called Backup_Sever with the location of
stlcopadmbkackup. When I try the command I get the error
Can't open dump device 'stlcopadmbkackup', device error or device off line.
Please consult the SQL Server error log for more details. (Message 3201)
and in the eventlog it indicates 'access denied' as the cause for the failure.
I've looked in the Books Online and searched the technet database to find an
answer. The Books Online does say that in creating the backup device permissions
are not checked. I've checked and double checked the permissions on STLCOPADMBK
and there shouldn't be any reason why access is being denied.
I've installed the latest service releases for version 6.5 so that shouldn't be
an issue.
Help
View 1 Replies
View Related
Jul 23, 1999
I am having problems when trying to dump to a network share (NT Network) from SQL Server 6.5 and would appreciate any insight this group can lend.
To setup this dump, I followed the instructions provided in the SQL Server FAQ (www.swynk.com) and have been able to successfully complete this task on a different server (so I know I'm editing the registry correctly etc..etc..etc..)
none the less,
Here is an exerpt from NT's Event Viewer:
SQL Server Scheduled Task: 16, 'Network Dump - EIWDATA' -- Status: Failed
-- Task Invoked on: 7/23/99 1:45:18 PM -- Message: Can't open dump device 'crosrvdumpeiwdata.dmp', device error or device off line. Please consult the SQL Server error log for more details. (Message 3201)
Thanks for any help :)
mtf8
View 1 Replies
View Related
Jul 20, 2005
I was wondering if there is a way to schedule a tast that will dump afixed width text file of all the new entries in a table. So if I hada table with likeusername - varchar(20)created - smalldatetimeI could get a weekly feed each week of all the new users in a textfile. I know I could write a script that would go through and do thisby looking at the time stamp, and the last time that the filepreviously ran and get the new dates but I was hoping there was abuilt way to do this. Or perhaps a more elegant solution.Thanks,Charlie
View 2 Replies
View Related
Jul 20, 2005
Hi:)I need to dump data from database in to *.sql file. I try it using DUMPDATABASE but it not work that I need it.So, how can I dump data from database in to *.sql file and then run itusing: osql -E -i nameOfDumpedDatabase.sqlThanks for help, greetings, gregory :)
View 4 Replies
View Related
Sep 7, 1999
The transaction log does not truncate despite all
attempts (no_log,truncate_only, etc...) This database is a subscriber
for replication. Tried the reconfigure with override.
There are no open transactions (dbcc opentran)
Need help fast !!!
Danke schoen
View 2 Replies
View Related