Is there a way to restore a job?

• ensten

  Valued Member

  Points: 57

  More actions

  August 11, 2003 at 9:33 am

  #106018

  My customer has created a job that contained several commands, by misstake most of the commands was deleted. Is there a way to get restore the information i the job? \Patrick

• Larry C

  Default port

  Points: 1463

  More actions

  August 11, 2003 at 9:44 am

  #469435

  The only way I know would be if you had scripted the job and kept the query. Then you could rebuild the job through the query.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  August 11, 2003 at 10:01 am

  #469437

  Restore MSDB database to another server, script the job and recreate it.