Agent jobs

Technical Article

Job Summary

  • Script

This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.

5 (10)

You rated this post out of 5. Change rating

2012-10-10 (first published: )

2,093 reads

External Article

Custom sp_start_job to delay next task until SQL Agent Job has completed

  • Article

The system stored procedure sp_start_job is a very useful T-SQL command that starts a SQL Agent job. The problem with this is that it starts the job and it doesn't wait until the job is finished and sometimes I want to start a job and wait until the job is finished and move on to another job or task that depends on the result of the previous job.


3,405 reads


Summit Launch Pricing Ends June 7


The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023....

Masking Columns in Azure SQL and SQL Server: Safeguarding Sensitive Data


Information security and privacy are key in today’s data-driven world. Sensitive data needs to...

Tales From The Field Weekly Wrap Up for the Week of 05-22-2023 Microsoft Fabric Launch & Moving Home Offices


 Hello Dear Reader!  Sorry this is so late, moving houses has gotten me a...

Read the latest Blogs


Not wanting to use a Cursor, but...


Ok, need someone to talk me off the cursor ledge on this one. I...

Better Communication Through Less Messaging

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Better Communication Through Less Messaging

MuleSoft Integration with Azure Key Vault

By Sukanya Konatam

Comments posted to this topic are about the item MuleSoft Integration with Azure Key...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers