SQL Server Jobs

• SQLRO

  SSCrazy

  Points: 2923

  More actions

  January 18, 2007 at 12:22 am

  #62163

  Hi,

  We have SQL Server 2000 database . Last week we shifted (Restored) all the databases to a new server with same configuration.We restroed master as well as msdb database.

  But some of our jobs do not execute on the new server on scheduled time. We have to manually execute these jobs. The task these jobs are performing are basically exporting data to excel file and then forwarding these files to concerned users (using xp_sendmail).

  One of the jobs also shows

   Can anyone help me in finding out the problem?What all the things should be checked in this case.

   

  Thanks in advance.

  Rohit

   

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  January 18, 2007 at 5:00 am

  #683958

  i think u have not updated the target server properties in the destination server. do that so that jobs will run fine.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com