I use the Task-Scheduler from SQL-SERVER 6.5 to backup and maintain databases. Have you any idea how I can clear the history automatically. I want to clear the history-logs older then 30 days and for 25 SQL-Server is it very costly to delete the history manually. Thanks.
View 1 RepliesI practiced log shipping in my home PC. It works fine. But there are 3 error dialog box populated for every 15 minutes. I enclosed screen shot.
1. DW20.Exe Application Error
2. Visual Studio just-in-Time Debugger
3. Sqllogship.exe Application Error
I got this error every 15 minutes. I delete everything such as maintenance plan jobs, replication, log shipping, mirroring in my SSMS. I can't find out the solution for this error. I didn't know, how to resolve this problem.
Please advice. :eek:
Thanks
Jayasri
Hi,
I'm developing an Ads system, which will have an scheduler functionality. Here's how it works: each hour a process will verify and publish an XML file with Ads that have to be shown at that hour. To display the Ad, the "NextDisplay" table's field has to be equal to currently date/HOUR. Then the process will update the "LastDisplay" field with the currently time and call a MsSQL stored procedure that will recalculate the NextDisplay time of the Ad.
My problem is doing this stored procedure. I've based my tables to allow the same schedule rules of the Windows Task Scheduler, so I have to verify each rule to calculate the next display time, but it's a difficult process, 'cause there are a lot of details to be considered.
I thought interoping with Windows Task Scheduler or seeing some code that do something like that, to have some ideas about how to implement it.
Suggestions?
Thx!
Hi,
I'm looking to run a "job" on a SQL database regularly (like scheduled by a "task scheduler") to updated my database.
It appears I can use SQL Service broker to run such a job.
Can I embed a "task scheduler" inside my SQL Server database to trigger this job each X seconds?
When I install the sp2 in a cluster,the database engine upgrade failed.I found the error log for the install at C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixHotFix.log.
Here's the part that mattered:
07/05/2007 15:34:18.319 Patching available passive node: NODEA
07/05/2007 15:34:18.319 Patching passive node: NODEA
07/05/2007 15:34:18.335 Waiting for first completed passive node
07/05/2007 15:34:18.491 Task Scheduler: Created remote folder for product instance target \NODEA
07/05/2007 15:35:00.194 Task Scheduler: Transferred payload to remote product instance target \NODEA
07/05/2007 15:35:00.194 Task Scheduler: Transferred payload to remote product instance target \NODEA
07/05/2007 15:35:00.241 Task Scheduler: Created new scheduled task for product instance target \NODEA
07/05/2007 15:35:00.663 Task Scheduler: Saved new scheduled task for product instance target \NODEA
07/05/2007 15:35:00.663 Task Scheduler: Created scheduled task for product instance target \NODEA
07/05/2007 15:35:00.663 Task Scheduler: Started scheduled task for product instance target \NODEA
07/05/2007 15:35:00.663 Task Scheduler: Started scheduled task for product instance target \NODEA
07/05/2007 15:40:06.817 Task Scheduler: Scheduled task for product instance target has completed
07/05/2007 15:40:06.817 Task Scheduler: Waiting for exit code from scheduled task for product instance target \NODEA
07/05/2007 15:40:11.817 Task Scheduler: Received exit code 29512 from scheduled task for product instance target \NODEA
07/05/2007 15:40:11.817 Task Scheduler: Result code for scheduled task for product instance target has been received
07/05/2007 15:40:11.817 Task Scheduler: Removed scheduled task for product instance target \NODEA
07/05/2007 15:40:12.333 Task Scheduler: Removed remote folder for product instance target \NODEA
07/05/2007 15:40:12.333 Remote process completed for product instance target
07/05/2007 15:40:12.333 Exit code for passive node: NODEA = 29512
07/05/2007 15:40:13.333 The following exception occurred: No passive nodes were successfully patched Date: 07/05/2007 15:40:13.333 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllinstance.cpp Line: 3422
07/05/2007 15:40:13.676 Watson: Param1 = Unknown
07/05/2007 15:40:13.676 Watson: Param2 = 0x2b01
07/05/2007 15:40:13.676 Watson: Param3 = Unknown
07/05/2007 15:40:13.676 Watson: Param4 = 0x0
07/05/2007 15:40:13.676 Watson: Param5 = instance.cpp@3422
07/05/2007 15:40:13.676 Watson: Param6 = Unknown
07/05/2007 15:40:13.676 Watson: Param7 = SQL9
07/05/2007 15:40:13.676 Watson: Param8 = Hotfix@
07/05/2007 15:40:13.676 Watson: Param9 = x86
07/05/2007 15:40:13.676 Watson: Param10 = 3042
07/05/2007 15:40:13.676 Installed product: SQL9
07/05/2007 15:40:13.708 Hotfix package completed
07/05/2007 15:40:13.708 Attempting to continue the 32 bit ngen queue
Any advise?Thanks in advance.
Hello,
I had configured a backup operation with SQL Server Express 2005 and saved the operation as a .sql file. I then configured a task with Task Scheduler to execute this .sql file at a specified time. The text in the Run box for this task is:
"C:Program FilesMicrosoft SQL Server90ToolsBinnSQLCMD.EXE" -S .SQLEXPRESS -i"C:Program FilesMicrosoft SQL ServerFull_M-Th.sql"
I verified this .sql file would run a backup by launching Management Studio Express, opening the file, and then clicking the Execute button. Minutes later, I had a backup. Yet the scheduled task did not run, nor would it run when I manually chose to run it from the list of scheduled tasks. I looked in the Event Viewer, but could not find anything that tipped me off to what I am not doing correctly. If anyone can tell me what might be wrong with the command I pasted above, it would be appreciated.
Thanks for reading!
This is my sql script :
DECLARE @countRows INT,
@currDate DATE,
@checkForTasks INT,
@created_by_id INT,
@gst_ID int;
SET @currDate = Getdate()
This is resided in videos folder of windows , i have created a task schedular in windows 8.1 to run daily at every 10 seconds , but it is not working ...
This sql query is running perfectly in sql server. Query have no errors.
I am new to the world of ETL. I recently started using SSIS and I have come across couple of questions on this.
1.Can we run a SSIS Package using windows task scheduler?
2. If the above answer is yes,I don't have the SSMS installed on my machine. Can a SSIS package run in the absence of SSMS?(I do have Visual studio and SQL server data tools installed)
3. Can a SSIS Package run in the absence of Visual studio and SQL Server Data Tools.Say for example, I create a SSIS package and then remove Visual studio and SQL server data tools from my machine. Will the Task scheduler still be able to run the SSIS package?
4. Does the SSMS free edition comes along with SQL server Agent?
Hi all,
I am trying to setup the cluster SQL server, say ServerA and ServerB. While I start the setup in ServerA, it prompts,
'Setup failed to start on the remote machine. Check the Task scheduler event
log on the remote machine.'
But I found that there is no remote logon to both nodes and the service task scheduler is running in both node.
On the other hand, I try to install the SQL via ServerB, it prompts for valid Native client package 'sqlncli.msi' and caused the setup failed finally. However, the Native client was setup successfully as a prerequisite once starting the setup.
Any advise? Thanks in advance!!
I feel stupid asking this because I have worked with SQL Server 6.0/6.5 for serveral years now, but I can't seem to find the task history in 7.0. When I look at a task, I can tell if each step ran or not, but I am used to seeing error messages upon failure by right-clicking on the task and choosing history.
How do I find this in 7.0? In casual looking for a few days, I've come up empty.
Thanks.
I have set up a history cleanup task to be performed once per week, however it doesn't seem to delete the old files, what am I doing wrong?
View 8 Replies View RelatedHi,
We are running sql server (e) v 6.5 as a cluster service on clusterted nt
servers version nt 4.0, sp3.
Scheduled tasks fail, but are recorded as successfull & the task
history for a task displays twice. Has anyone experienced a simillar
situation.
Appreciate assistance ASAP.
Regards
Vedanth
Hello,
Where can I locate NT Scheduler in Win NT 4.0?
Thanks
Sejal
I have a scheduler doing ftp and bcp to SQLserver. How do I check the file size is greater than 0
after ftp completed? (right now I am using xp_cmdshell to execute ftp command and return 0 always,
even the file did not get transfer successfully).
DECLARE @result_ftp int,
@result_bcp int
EXEC result_ftp=xp_cmdshell @ftpbat
if (@result_ftp=0) ???? xp_cmdshell always return 0 ????
BEGIN
EXEC result_bcp=xp_cmdshell @bcpbat
if (@result_bcp=0)
print ' ## BPC Successfully##'
else
raiserror("BCP Fail", 16,1)
END
ELSE
print ' FTP fail'
return
Go
Dear friends,
Currently i am running a large sql server 2000. Usually when i need to generate reports, i will need to query using query analyser and paste the result in excel. This process is very tedious as the query takes long time due tolarge data. Also my reports have the frequency of daily, weekly and monthly.
I am looking for a job/query scheduler to automate this process and publish the result in excel.
I understand that DTS can only schedule a query to run but extracting the data to excel and Reporting Services does not have scheuler.
Please advise if there is any s/w or application can do this. Any freebies?
Cheers,
Darren
Hello,
I am have problems running a couple of jobs. It makes no sense. I have checked and made sure the agent service is running the same user level permissions as I am. I run the job manually from SMS and it works fine.
User is a Windows Login.
Any suggestions would be greatly appreciated.
Date 6/11/2007 6:00:01 AM
Log Job History (BidBackLog)
Step ID 1
Server TWSQLRPTS
Job Name BidBackLog
Step Name Step1
Duration 00:00:21
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: TWDOMAINSQLADMIN. ... 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 6:00:01 AM Error: 2007-06-11 06:00:22.50 Code: 0xC0202009 Source: BidBacklog Connection manager "TWSQLRPTS.HomeBASE" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Login failed for user 'TWDOMAINSQLADMIN'.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot open database "HomeBASE" requested by the login. The login failed.". End Error Error: 2007-06-11 06:00:22.50 Code: 0xC020801C Source: DTSTask_DTSDataPumpTask_1 OLE DB Source [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager ... The package execution fa... The step failed.
What is the best way to run a scheduled task that fires off three scripts that need to be run sequentially? I could set up three different tasks but I don't know exactly how long each will take and they are interdependent.
View 2 Replies View RelatedI have several DTS packages that I run in steps thru the scheduler. The only one that is giving me grief is one that extracts large amounts of data from an Oracle database. Any extract that is less than 30,000 rows is fine but more than that, only the last completed batch that keeps the rows returned under 30,000 will write out to either a new table or to a file. Not only do the rows not return, but it holds open any file that is being used (the one it is writing out to as well as the errorlog file.) I have changed batch sizes, max error counts, timeouts and every other variable I could find to no avail...The job immediately 'completes' its execution with a good return code but that appears only to be 'I sent your request off to Oracle' which releases the next step even though the data hasn't been returned (an issue I will tackle once I get all the data.) My Network folks and Oracle DBA are telling me that there are no size restrictions for passing the data back.
Any ideas where I have strayed off the path? Thanks for your help.
Marianne G. Burhans
Sr. Database Administrator
All,
I'm getting the following error in my SQL logs:
Process 51:16 (2bc) UMS Context 0x1249F118 appears to be non-yielding on Scheduler 0.
I killed the process, but it's been rolling back for 3 hours. It's done zero IO and consumed a TON of CPU time.
Any suggestions as to what I can do?
Thanks,
Isaac
We have created a Job in the SQL server Agent to execute some of the tasks which will load the data from XML to DB. These jobs will run exactly 15 days then they will get hanged. We need to restart the server to start the job again.
Could anybody give the suggestion to solve this problem.
Thanks in Advance and Regards,
Vasant Ghooli
our sql 05 server running on 64 bit slowed down and became non-responsive after getting this initial message Non-yielding Scheduler and then flooding the system with this message and become non-responsive.
Process 62:0:0 (0x11a0) Worker 0x00000001371DE1C0 appears to be non-yielding on Scheduler 0. Thread creation time: 12828422717058. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process Utilization 0%. System Idle 96%. Interval: 70050 ms.
i restarted the server as , i could not stop the services running , as the view processess window in sql server had become non responsive and i could not kill or even view the processes ...
no idea what caused it or how this can be stopped from happening again,
please advise if you have encountered this problem
thanks
Hi Guru,Our HR sql 2000 production server is 800.760 built (SP3a) with 2GB ofRAM and 2 CPU hiper threading. This server is very low activity whereprocessor runs average 1-3 during the day. However, in the last twomonths, I've seen the following message occurred a few times on thisserver.Error: 17883, Severity: 1, State: 0The Scheduler 2 appears to be hung. SPID 0, ECID 0, UMS Context0x0381F660.I did extensive research and read both KB 815056 and 10885 but I couldnot correlate these KBs in to my issue. The reason is, I don't thinkour server is very busy to cause the checkpoint process to be delayed.The database keeps growing only 5-10MB in a week and I allocated thespace during off hour.What is the solution to fix this issue? Will I fix this issue byapplying the hotfix MS03-031?Thanks so much,Silaphet,
View 1 Replies View RelatedIs there anyway you can schedule to restore a database table(s) from a backup file *.bak?
View 3 Replies View Relatedhi thank you for this solution Hugo (dutch?) and it's very handy, thankyou but my issue is that we created dozens of views with my function.This functions returns an integer of a date. This function has to give alowerlimit and higherlimit back when dates are out of Calendar range.But i want to read this from the Calendartable ONCE and store it in aglobal variable somewhere in SQL Server. I DON'T want to referencetables in my function. SO read once the lower- and upperlimit and usethis variable/property for referencing in my function!!GreetzHennie*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 11 Replies View RelatedI have a DTS package that I want to execute from within a sql 7.0 scheduled task step. I tried the following and got the following error on the DTS step:
Operating System Task:
dtsrun /S 'Server1' /E /N'REFRESH'
Error Thrown:
DTSRun: Loading... Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713 Error: -2147467259 (80004005); Provider Error: 11 (B) Error string: [DBMSSOCN]General network error.
Can someone help me with the syntax? Suggestions?
I am calling a sp_procedure from a scheduled task, it seems to complete ok , it has a return code = 0 in the history and the output looks ok.
The problems is that in the summary page its last_run_status it shows a a failed.
I think is due to the system output messages from dropping a table and doing a bcp.
My questions is how do I mask the output for this system messages?
Thanks,
josie
Hi,
Below messages got throwed to sql ErrorLog. I could'nt understand what it means.. any help is appericated.
The Scheduler 2 appears to be hung. SPID 0, ECID 0, UMS Context 0x03CBAA40.
Error: 17883, Severity: 1, State: 0
WARNING: EC 36b9c098, 8 waited 300 sec. on latch 444f3b84. Not a BUF latch.
thanks,
-J
Hello,
The users of my microsoft SQLServer 7 database could not log on to the database after the following message has appeared in the log file;
The Scheduler 0 appears to be hung. PSS 0x5B1630C8, EC 0x5B163278, UMS Context 0x3FC37E88
The problem was solved after I have restarted the database. I would be grateful if you could show me how to avoid such a problem in the near future.
Regards,
Albert
Hi,
I have a schedule task with the following command:
xp_cmdshell 'bcp DBName.TBLOwner.TBLName in h:datafile.txt /fh:formatfile.fmt /Sservername /Usa /Ppassword'
The error message that I recieved is "Unable to open Host file. I can run the BCP command in Dos C prompt successfully, but
cannot run this in the SQL Server Scheduler. H drive is net use to the Server and it is where my data file and format file located.
Does anyone has any idea? I do appreciate for your help.
I have a job that was running on the SQL Server every business day. Once I disabled the scheduler for a day or two and then enabled it again. Well, now every once in a while my scheduler disables itself. Is there any logical explanation of this phenomenon?
View 1 Replies View RelatedHi, here is my problem:
Because of some usability terms, I need to use SSRS scheduler to determine reports creation frequency (minimum frequency is once a day)I need to use an external scheduler to SSRS in order to launch reports creation daily, after some other batch tasks execution that must be completed before launching report creation.
And I have no idea on how to do that properly. Can somebody help me?
Thanks!
I am hoping this is something simple, a security piece I've messed up.
When I run my dts package manually I get no errors and sucessful completion of each step. So I set my SQL Agent to run thepackage 15 minutes after every hour between 5am and 5pm, these being 15 minutes after the times the new data files are dropped to me.
But instead of running the package it disconnects all the remote desktop users and fails. When remote users can get back on we are faced with a system has recovered from a serious error message. The error message posted to the event logs is empty though.
Any one have any ideas?
We are running MS Server 2003 and SQL Server 2000
Thanks,
Carrie
Hi, I have read that service broker can be used to manage and schedule jobs. but how is this more of an advantage compared to the current sql server job scheduling using the sql server agent. thanks in advance. Would appreciate if somebody can answer immediately
View 2 Replies View Related