scheduled a DTS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

scheduled a DTS

Author

Topic

hong_ma
Starting Member

37 Posts

Posted - 2006-02-14 : 10:08:00

I scheduled a DTS running every day. the jobs under the Management gave some messages, looks like
Name , Category, Enabled, Runnable,Schedules, Status, Last Run Status
MyDTS,Uncategorized(local),Yes, Yes, Yes, Not Running,Failed(time) .

can anyone tell me what's wrong. I am not a DBA, This DTS not belong to sa. is it a problem?

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-02-14 : 11:12:10

Ur DTS might have failed
-- be sure u don't do any harm to ur data
-- do the following if u do know the impact of running the DTS
U can run it and c where it is failing. (Go to Local Packages, right click on the corresponding package and select design package and run it )
U would find where it is failing and why it is failing : eg. some primary key violation of some table ...
So do the needful

hong_ma
Starting Member

37 Posts

Posted - 2006-02-14 : 11:22:30

after I went to local packages, then went to the execute package and ruu it. it works.I got a message, successfully completed execution of package.

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-02-14 : 11:38:29

Then go back to Scheduling and schedule a time 10 minutes after current time (of the server) and wait and c whether its running successfully. If OK change the shedule time to whatever u want - eg. daily at 10.00 PM or any such and c the result after that time is passed.

When it is running (I mean when u look the Management ... and keep it refreshing when the package is running (scheduled running) - u'll c the failed msg as running or something similar to that.

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-02-14 : 13:12:32

changing scheduling time is the solution?????

u CAN SEE THE REASON OF FAILURE by checking show steps details in job history

T.I.A

Papillon

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-02-14 : 13:42:23

quote:
Originally posted by under2811

changing scheduling time is the solution?????

I didn't say that. I wanted to take hong_ma thru step by step to find where the error causes and whether the error causes again.

Still I'm in the process of giving him guidance. U can come in to ur conclusion if my final suggestion is to change the schedule time, which I never think will be a resolution.

hong_ma
Starting Member

37 Posts

Posted - 2006-02-14 : 14:47:11

Thanks, your guys, when error message in job history is

The job failed. The Job was invoked by Schedule 98 (DTS_Call_Insert_SP_1). The last step to run was step 1 (DTS_Call_Insert_SP_1).
what's that mean? Thanks!

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-02-14 : 15:05:50

hi..

can u check the upper right check box for show steps details here..u will get detail reason for failure...

hong_ma
Starting Member

37 Posts

Posted - 2006-02-14 : 16:06:53

Thanks, I got detail error message.
Non-SysAdmins have been denied permission to run CmdExec job steps. The step failed.
is that mean that the package should belongs to the sa? Thanks.

bakerjon
Posting Yak Master

145 Posts

Posted - 2006-02-14 : 17:21:48

Changing the job owner to SA could help. If the job executes an OS command, sa will be impersonated by the SQL Server Service account or the proxy account if you set it up.

Jon
When your forehead becomes flat, find another wall to hit it against.

http://www.sqljunkies.com/weblog/outerjoin

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources