Existing SQL 2005 job is not showing steps and schedules.

• Venkat Rao-440631

  SSC Veteran

  Points: 268

  More actions

  September 9, 2008 at 1:46 pm

  #123506

  Hi Friends,

  In out production server, when i rightclickon SQL job -> click on Properties, the properties window's left pane navigation to Steps, schedules are not displaying steps contained in the job and schedule at which the job is scheduled. More over the job is not running automaticcally at the time it was configured. More over when i generate the script for the job, it is showing the schedule, steps and everything. could somebody help me to make the job to run as per the scheduled time.

  Thanks in advance for your help.

  Thanks & Regards,

  Venkat.

• Jack Corbett

  SSC Guru

  Points: 184388

  More actions

  September 9, 2008 at 2:01 pm

  #869286

  What happens when you tun the job manually?

  You could generate the script, verifying that I have everything I expect and then drop the job and re-create using the script.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question