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 - 2007-07-10 : 09:54:28
|
Hi I have migrated some jobs from one server to another server by scripting the jobs and executed those scripts on target serversBut i see NEXTRUNDATE as 'Date and Time are not available'The job is scheduled to run every 5 minutesThe SQL Agent servics is also up and runningPlease guide me on this.Thanks |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-10 : 11:04:59
|
What does the job do? Who is job owner? Can you run it manually? |
 |
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-11 : 15:37:34
|
had the same problem, either your job is not enabled or schedule is not enabled, some jobs also put an automatic expire date, like replication jobs.Need an SQLDB consultant?check www.veeningsengineering.nl |
 |
|
|
|
|