script job scheduless

• sqlfriend

  SSC Guru

  Points: 52781

  More actions

  November 8, 2016 at 4:01 pm

  #331846

  I would transfer jobs from one server to another server.

  I can script out using SSMS for all the jobs using object detail view.

  But I found there are no schedules carried over.

  So I guess the schedule cannot be scripted out.

  Is that true

  Thanks

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  November 9, 2016 at 2:58 am

  #1911351

  No, the schedule can be scripted out. Why not?

  Igor Micev,My blog: www.igormicev.com

• HanShi

  SSC-Dedicated

  Points: 33507

  More actions

  November 9, 2016 at 4:36 am

  #1911368

  sqlfriends (11/8/2016)

  ---

  I would transfer jobs from one server to another server.

  I can script out using SSMS for all the jobs using object detail view.

  But I found there are no schedules carried over.

  So I guess the schedule cannot be scripted out.

  Is that true

  Thanks

  No, that's not true. The schedules are included in the script. You'll find it near the bottom of the script, starting with

  EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, ...

  Have you checked the job actually has a schedule attached?

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

• sqlfriend

  SSC Guru

  Points: 52781

  More actions

  November 9, 2016 at 10:16 am

  #1911452

  Sorry, I saw in job activity monitor and see next run not scheduled. what I should look is the Scheduled column.

  For next run we temporarily disabled it for the period of migration.

  So you are correct, it does script the schedule too