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.
| Author |
Topic |
|
shehz
Starting Member
10 Posts |
 Posted - 2006-10-05 : 16:09:01
|
| Here is the scenario:I created a package and saved it. I right click on the package and schedule a time. The package didn't run - what else do I need to make sure the package runs? sql server agent..what else??YEs I know its an old sql but it was running earlier but now its not. I have to run the package manualy and its always successfulAnother screwy part is when I hit okay for the schedule time, and open the schedule to update, it doesn't save my previous settings. Is that a known issue for sql 7 or it saves it but resets to default values when I open it?Thanks guys! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-05 : 16:10:00
|
| So is the SQLSERVERAGENT service started? Is the job enabled? Is the job schedule enabled?Tara Kizer |
 |
|
|
shehz
Starting Member
10 Posts |
Posted - 2006-10-05 : 16:21:42
|
| sql server agent enabled - checkIs the job enabled? Is the job schedule enabled? - I think that could be ithow do I check that? thanks for the reply :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-05 : 16:40:15
|
| You would check the properties of the job.Tara Kizer |
|
|
|
shehz
Starting Member
10 Posts |
Posted - 2006-10-05 : 17:45:43
|
| sql server agent enabled - checkIs the job enabled? Is the job schedule enabled? - I think that could be ithow do I check that? thanks for the reply :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-05 : 17:46:30
|
| Why the duplicate post?Tara Kizer |
|
|
|
shehz
Starting Member
10 Posts |
Posted - 2006-10-05 : 17:46:54
|
| Yes the job was enabled but there was a permission issue!! It's now working . thanks for the idea!! |
|
|
|
|
|
|
sql server 7 DTS not running