SQL Agent jobs could not start

• acmh

  SSC Journeyman

  Points: 81

  More actions

  June 2, 2003 at 6:09 pm

  #106427

  Hi guys,

  I wonder if you could help me out with this problem. I have created a simple 2 step job that actually does the same thing which is as follows:

  *Step 1

  select * into XXX from YYY

  *Step 2

  select * into YYY from ZZZ

  For some reason when I try to run this job in Enterprise Manager, it starts up for a while (about a few seconds) and then stops without giving me a Last Run Status. I checked the Job History but there is nothing. I also checked the Event Log found nothing suspicious. What else could be wrong? By the way, the server is up for almost 3 months. Do I need to restart for some reason? Please help.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 3, 2003 at 4:57 am

  #459503

  Try scripting out the job and post here. Might be something in the settings, but nothing I can think of.