• Syed Jahanzaib Bin hassan (4/21/2011)


    That is a serious issue,did you check to bounce the agent service,

    for the time being create an sp and include all jobs start script as

    sp_start_job 'test1'

    sp_start_job 'test2'

    and so on......

    and then create a batch file with SQLCMD and schedule it on OS level

    Regards,

    Syed Jahanzaib Bin Hassan

    MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog

    http://www.aureus-salah.com[/quote%5D

    Wow talk about yet ANOTHER moronic post (see his last 5-10 posts). What about the consequence of running a job at the wrong time or taking production down because you just overloaded the server?