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)
 Unable to start the job

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 servers

But i see NEXTRUNDATE as 'Date and Time are not available'
The job is scheduled to run every 5 minutes
The SQL Agent servics is also up and running

Please 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?
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -