Scheduled Tasks

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


ADVERTISEMENT

Scheduled Tasks

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

Scheduled Tasks In 6.5

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

Scheduled Tasks

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

Scheduled Tasks

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

Scheduled SQL Server Tasks (6.5)

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

Scripting Up Scheduled Tasks

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

SQL Executive And Scheduled Tasks

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

Scheduled Tasks Not Running?????

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

Scheduled Tasks Don't Complete

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

Scheduled Maintanance Tasks - Help

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

MSDE Scheduled Tasks

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

Using SSIS Instead Of Scheduled Tasks?

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

Creating SQL2000 Scheduled Tasks

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

Changing Sa Password Causes Scheduled Tasks To Fail.

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

Scheduled Tasks Failing Because Of Email Notification

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

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 View Related

Capture DBCC CheckDB Result In Scheduled Tasks

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

What Data Mining Tasks Can Be Automated And Scheduled Via Integration Services Packages?

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

More Of DBA Tasks

Apr 11, 2006

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?


TIA

--------------------
keeping it simple...

View 2 Replies View Related

DBA Tasks

Feb 21, 2008

Hi guys

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.

What else you guys record?

Thanks

View 3 Replies View Related

How To Run Only Certain Tasks

Mar 14, 2006

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

View 11 Replies View Related

Where To Find The Web Tasks?

Dec 17, 2001

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.

View 1 Replies View Related

DTS Custom Tasks

Oct 5, 2000

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

Thank You...

View 2 Replies View Related

Schedule Tasks

Jun 5, 1999

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.

Thank you,
Sev

View 1 Replies View Related

Transfer Of Tasks

Jun 28, 1999

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!

Thanks.
vic

View 1 Replies View Related

DTS Workflow And Tasks

Jul 12, 2005

Hi all,

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

Thanks.

View 2 Replies View Related

How Often To Do Certain Maintanence Tasks.

Jul 29, 2004

Hi,

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:

Thanks so much for your advice.

View 5 Replies View Related

Tasks To Automate

Mar 2, 2006

Can someone let me know any 10 things that are usally automated using the SQL Server Agent,

I mean besides backup what all can i automate

Thanks

View 1 Replies View Related

Plz Solve For This Tasks

May 13, 2006

could some one help in giveing solution for this tasks..
[CODE]
Task 1 : Get the first day and last day of the week


Ex: input : '04/12/2006'

Required ouput :

start_date End_date
04/09/200604/15/2006

Note :1. start_date should be sunday
2. end_date should be saturday




Task 2 -- Find the product sales week wise


Find the product sales week wise

Output Required:

gasstationID productClass week1 week2 week3 week4
-------------------- ------------ ----------- ----------- ----------- -----------
111 DSL 1 0 0 0
111 GAS 2 0 1 1
222 DSL 1 0 1 1
222 GAS 1 0 0 0


create table trial_sales(
gasstationIDbigint,
salesDatesmalldatetime,
gallonsbigint,
productClass varchar(4))


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.

p1 p2 p3 s1 d1 s1
1 12 14 100 23May comment 2
1 12 14 800 22May comment 1
1 12 14 300 24May comment 3
1 12 15 100 22May comment 2
1 12 15 800 21May comment 1
2 12 15 100 23May comment 1

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:

p1 p2 p3 s1 d1 s1
1 12 14 300 24May comment 3
1 12 15 100 22May comment 2
2 12 15 100 23May comment 1





Task 5


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?



Task 6

I have two tables as below, TABLE1 and TABLE2.


TABLE 1: Base

IDPNamePPrice
-------------------------------------
1A30
2B20

TABLE 2: History

IDLdateAmount
-------------------------------------
12005/8/750


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:


LdatePNameAmount
------------------------------------
2005/8/7A50
2005/8/7Bnull


and when I pass the date of 2005/8/8, it will return the result as below:

LdatePNameAmount
------------------------------------
2005/8/8Anull
2005/8/8Bnull



Task : 7

Reverse the Name

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


[CODE]

thanks in adv
chakri

View 5 Replies View Related

Run Tasks Against Each Sql Server

Jun 18, 2008

Hi,

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

...
...
...

The list goes on

Thanks

View 7 Replies View Related

Tasks To Automate

Mar 2, 2006

Can someone let me know any 10 things that are usally automated using the SQL Server Agent,

I mean besides backup what all can i automate

Thanks

View 10 Replies View Related

Daily Tasks

Jun 6, 2007

Just wonder what do you dba do in your daily tasks. I usually have meetings where I have to say what Ive been doing during the week.


=============================
http://www.sqlserverstudy.com

View 1 Replies View Related







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