Post reply

Running scheduled jobs in parallel in multiple processor server

  • August 13, 2009 at 11:45 pm

    #385182

    Hello,

    I have to import around 200 different files in different tables. For this i am thinking of creating jobs which can be scheduled. But I have no idea how to run this diffent import parallely in a multiple processor server so that i could utilise different processor and finish the job fast.

    Any suggestions for this kind of job?

    Thanks in advance

    regards,

    sameer.

  • August 14, 2009 at 7:19 am

    #1039307

    You could simply schedule each job to start a the same time. You could also set up a "runner" job to start all the other jobs with msdb.dbo.sp_start_job.

    For what parallelism is concerned, it's up to the SQL Server engine to decide how to use the processors. I suggest you don't try to get into this and let the engine do its best to distribute load through all processors.

    Regards

    Gianluca

    -- Gianluca Sartori

  • August 14, 2009 at 8:23 am

    #1039399

    I'd look at SSIS. If you put the tasks on designer without precendence constraints, they'll run in parallel.

Viewing 3 posts - 1 through 2 (of 2 total)

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