Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Schedule problem

Status
Not open for further replies.
dpk136

dpk136

MIS
Jan 15, 2004
335
US
I have a DTS and it runs fine manually. I am wanting to schedule the DTS to run every 15 minutes. When i go into it and put in all the information in the scheduling screen, it looks like it works. Then I click OK and think that it will work. It doesn't...I go back in and the schedule is back to the way that it was. Please help. This project is a rush and i can't figure it out.

Thanks

David Kuhn
------------------
 
Sort by date Sort by votes
The scheduling screen will always look the same. Under the SQL Server Open managment, then SQL Agent, then Jobs. Your jobs will be in there.

You may have extra jobs that you need to delete, or extra schedules that can be deleted. You'll need to look at the job to be sure.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
Donate to Katrina relief
 
Upvote 0 Downvote
Make sure the job is enabled.. Right click the job to enable.

Dr.Sql
Good Luck.
 
Upvote 0 Downvote
Under the SQL Server Open managment, then SQL Agent, then Jobs. Your jobs will be in there.
Click to expand...

Where is this tool. I cannot find it. is it under SQL Server Enterprise Manager. I'm running Version 8. i have no idea where any of this is. please help...

David Kuhn
------------------
 
Upvote 0 Downvote
In Enterprise Manager click the + next to the server name, then the one next to Managment, then the one next to SQL Server Agent, then select the Jobs menu item that is under SQL Server Agent.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
Donate to Katrina relief
 
Upvote 0 Downvote
i found it and can't find out where the error codes go... the schedule is in there and it says that it didn't run.

David Kuhn
------------------
 
Upvote 0 Downvote
Make sure that the SQL Agent is started. The Service SQLSERVERAGENT should be set to automatic so that it starts each time the server is started.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
Donate to Katrina relief
 
Upvote 0 Downvote
Did the job run and fail, or just not run?

If you right click the job and select view history it will give you some information as to why it failed.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
Donate to Katrina relief
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
164
petart
petart
MICKI0220
  • Locked
  • Question
Overflow problem when importing to sql 2008
Replies
2
Views
112
drlex
drlex
MICKI0220
  • Locked
  • Question
Overflow problem when importing to sql 2008
Replies
0
Views
68
MICKI0220
MICKI0220
dandot
  • Locked
  • Question
Text Delimiter Problem
Replies
0
Views
60
dandot
dandot
DKibblewhite
  • Locked
  • Question
DTS Problem
Replies
1
Views
63
mutley1
mutley1

Part and Inventory Search

Sponsor

Back
Top