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.
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?
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?
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.
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.
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?
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?
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?
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?
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.
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.
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.
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.
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.
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....
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?
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.
are there restrictions on what a DBA can do on a developer's edition?
i'm asking coz i get really bad connection problems when changing service accounts, client aliases, port numbers, connecting to different components like ssis, reporting services, database engine, etc...
in sql2000, changing these things are a breeze, is there some guidelines when making these changes in 2005?
Just want to know whether you guys do the following as a dba:
1. Setup a logging for tracking database as well as table size that containing size, indexing size. You can measure the growth. 2. Record for indexing for each database. I think this is over kill task. 3. Record database setup such as create statistic, update statistic etc.
These tasks can be automate to record every month for example and record this into Administration database for instance.
If I'm in the Data Flow tab in VS 2005, how can I select only certain components to run to test? I tried highlighting the ones that I want to run but it's running all of them in the tab...some of the components I want to take out for testing then maybe put back in later. If I delete the tasks I don't want to run, then I end up having to recreate them
Where to look for the web assitant created jobs on the server?I created a web page using the web assistant which is suppossed to get updated each time a value changes in a particular table,but I can't find the task which I created ,where do i look for that?I didn't use this wizard previously.thanks for any help! Sheila.
Would anyone be aware of anyplace I could find some good information on creating DTS custom tasks? I've come across a couple of articles from SQL Server Magazine, but nothing too substantive... Better yet, if anyone has any success (great or small), I'd like to hear from you and hear some of the things you did, what your custom task does, difficulty. I'm just trying to get an idea of how much work I have ahead of me....
Hello , I need create tasks, which will be wake up daily to backup 4 databases. My questions are: 1. Can I create 1 task to backup all databases using TSQL command? Ex: DUMP DATABASE test1 to test1_backup DUMP TRANSACTIONS test1 to test1_backup with truncate_only DUMP DATABASE test2 to test2_backup DUMP TRANSACTIONS test2 to test2_backup with truncate_only Etc. If it’s possible can I just print this command to ‘Command:’ text box in the ‘New task’ window without writing the TSQL command into a text file and execute it with the ISQL program through CmdExec?????? 2.If first doesn’t work: can I do the same job, but create for every backup own task and run the same TSQL command for particular database. And if I can is it possible to schedule run all 4 tasks the same time or I should put time’s interval? 3. If 1. And 2. Are false. Give me your smart advice.
Is anybody knows how to transfer all the tasks in one server to another? Our development database will be transferred/copied to a new production box and that includes all tasks that we've created. We have almost a hundred tasks defined and we don't want it create manually. If someone had done this before, please give me a hint, i appreciate it very much!
I've got a DTS job which has lots of tasks in it. I've also got quite a few flows of workflow and i've noticed that a task won't execute if it has both Failure and Success workflow pointing to it... It can have multiple failures pointing to it and it will execute but it can't have multiple successes or a combination of workflows...
Does anyone know a way to get around this or to change the 'AND' ing that seems to be on the workflow going into a task..
I just volunteered to be the database administrator of our new sql server. I am normally the programmer so I have little experience with database administration. There are some basics that I need some assistance with mainly when to perform various maintanence checks. For example, how often do I need to perform some of the dbcc commands that I have read about? How often do I check for data integrity, index fragmentation, rebuilding indexes, or defrag indexes?
I have to come up with a plan by tomorrow and I don't know if I have anything solid enough since I don't exactly know when to perform some of these tasks. :confused:
insert into trial_sales values(111,'11/01/2005',10000,'GAS') insert into trial_sales values(111,'11/02/2005',1000,'GAS') insert into trial_sales values(111,'11/02/2005',20000,'DSL') insert into trial_sales values(222,'11/01/2005',10000,'GAS') insert into trial_sales values(222,'11/02/2005',10000,'DSL') insert into trial_sales values(111,'11/15/2005',1000,'GAS') insert into trial_sales values(222,'11/15/2005',10000,'DSL') insert into trial_sales values(111,'11/25/2005',1000,'GAS') insert into trial_sales values(222,'11/25/2005',10000,'DSL')
Task 3 Display unique values
Display unique values in
create table t (colA varchar(25))
insert into t values('apple') insert into t values('bat') insert into t values('car')
ouput required:
a b c e l p r t
Task : 4
I have a table in the database I am working with with the following columns: (I have simplified this down for the sake of clarity) int p1 int p2 int p3 int s1 date d1 string s1
There is no primary key and the table more resembles a log than anything. e.g.
What I want to do is exttract the rows from the table where the combination of p1 p2 and p3 is distinct/unique and the date is the most recent one for all combinations of p1, p2, p3. So from the table above I would end up with the resultset:
say i have the following data... uId(int PK), productcode(int), quantity(int) 1,12,5 2,12,3 3,12,5 4,11,9
....and i have an order for productcode 12 with quantity of 6 products. i need to select only enough rows to reach a quantity of 6. in this case, i would want the first two rows which would give me a sum of 8. how can i do this without looping through each record, getting the quantity and exiting the loop when i have a sum >= 6?
The ID of TALBE1 is the primary key and the ID of TABLE2 is the foreign key. What's the right T-SQL JOIN statement when I pass the date of 2005/8/7, it will return the result as below:
create table sample_judge( judge_namevarchar(50)) go
insert into sample_judge values ('J Smith') insert into sample_judge values ('M Samuel') insert into sample_judge values ('S Shan') insert into sample_judge values ('K Anand') insert into sample_judge values ('K K K K Anand') insert into sample_judge values ('K R Shanth Anand') insert into sample_judge values ('K R Shanth Anand Kumara Velu')
go
Expected Output :
Smith J Samuel M Shan S Anand K Anand K K K K Shanth Anand K R Shanth Anand Kumara Velu K R
I would like to run several checklists against each sql server 2005 instance.
I can get a list of the sql server 2005 machines (Which are on the network) from a sql server table.
There is a another table which holds the list of the checks that need to be carried out against each sql server 2005 machine called tblCheckList.
The list of tasks in the table is briefly as follows:
1) get the path where the .mdf file is placed. 2) get the path where the .ldf file is placed 3) get the path where .BAK or .TRN are placed 4) get the path where the sql 2005 is installed 5) get the servicepack version 6) get the authentication 7) remove sample databases i.e. northwind or pubs, etc... 8) get the recovery model on UserDB 9) get the size of each database
