Post reply

Identify running SSIS jobs

  • January 4, 2008 at 7:18 am

    #119595

    Hi Folks,

    I am currently in the middle of developing a prototype to do the following:

    We are going to have a number of jobs that are running for a length of time say an hour at a time. I want to write a procedure to check every five minutes if the job is running. If the job has stopped unexpectedly then I want to send an email.

    Does anyone know the new dynamic view that will list the SSIS jobs that are running on a server?

    Thanks in advance,

    M

  • January 4, 2008 at 7:24 am

    #764832

    Sorry folks,

    I just found it. rgds,

    exec msdb.dbo.sp_help_job @job_name = 'Copy Backups'

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

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