Post reply

Controlling Agent jobs from T-Sql

  • July 16, 2003 at 1:35 am

    #82725

    I can start an agent job using the command :

    msdb..sp_start_job @job_name = 'My Agent Job'

    Does anyone know how I can see if a particular job is running, and maybe even find out if the last run was successful or not?

    Thanks.

    Rick Jewson


    Rick Jewson

  • July 16, 2003 at 11:07 am

    #465702

    In SQL Server 2000 i use to query on sysjobs, sysjobhistory tables and find when it was last rum ,or whether the job i s already running and whether it ran successfully or not, find out more in BOl for sysjobhistroy table... in msdb database...

    I hope this helps..

    Bye

    Jay

  • July 16, 2003 at 11:36 am

    #465704

    You can use sp_help_job to view status of your own jobs if you are not the member of sysadmin.

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

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