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 |
venkath
Posting Yak Master
202 Posts |
Posted - 2006-06-14 : 03:15:17
|
Hi guysI created and scheduled a job to refresh the procedures at 1 clock in the night..when i check next day about the status of the job,there is no job history.. and job did not run..The job was enabled when it was created.The following are the parameters i got when i select the job in the enterprise manager..status-Not runningLast run status-unknownnext run date- date and time are not available.could any one pls help on this issue.. what might be the problem with this job..Thanks |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-06-14 : 04:42:21
|
1. Can you manually start the job?2. Is your SQL SERVER AGENT service running?------------------------I think, therefore I am - Rene Descartes |
|
|
venkath
Posting Yak Master
202 Posts |
Posted - 2006-06-14 : 04:54:59
|
No..Agent is not running..can i make it to run automatically when the o/s starts...Thanks |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-06-14 : 05:42:09
|
Yes you can do that!For any scheduled acivity you need the agent to run all the time!------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|