Offline-Jobs schedule

  • I have scheduled my jobs successfully and they run fine in SQL Server Agent 2008. But When I shutdown my system or close SSMS and the Agent, the jobs fail. Is there any way to make the SSIS Jobs run when SQL Server Agent is offline or when the System is shutdown.

    Here SQL Server is installed on my local machine which itself acts like a server. Thanks in advance.

  • You are asking to do computing on shutdown machine. It is not possible. To do any process your database should up and accessible. Now if you do have job it will not execute unless and untill SQL Server Agent is running. So that option is also ruled out.

    I am still trying to understand what you are trying to achive?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • concur, not possible, what is your goal?

  • Just wanted to know if SQL Server Agent can run in standby mode.

  • ssis2008r2 (4/8/2014)


    Just wanted to know if SQL Server Agent can run in standby mode.

    You mean while the computer is powered down? As far as I know, pretty much nothing at all can run.

    You might like to take a look here if you are in the mood for writing some code to wake it up for you.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply