Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2024
  • Last Modified:

check sql job status if completed

I have a sql job that is executed via stored procedure...

how to i check if the execution of the sql job has been completed, coz i need to update data on the table where the sql job inserted data...

some code snippet for validation would help a lot.. thanks...
0
praetorean
Asked:
praetorean
2 Solutions
 
Chandan_GowdaCommented:
Please try the below query
Select 
 * 
From  
 msdb..sysjobhistory  as sysjobhistory
   Join  msdb..sysjobs as sysjobs on sysjobhistory.job_id=sysjobhistory.job_id
Where 
 Name='JOB_Name'
Order By 
 Run_Date Desc, 
 run_time Desc

Open in new window

0
 
praetoreanAuthor Commented:
Hi Chandan_Gowda,

i got the code to work... i got a large result set to show me the status of the jobs... i was hoping for a single resultset to validate for the status of the sql job... the flow is as follows:

1- app invokes a stored procedure
2- store procedure executes a sql job
3- after the execution of the sql job; would like to validate if execution has been completed and successfull
4- if validation on item # 3 = true; update certain columns of the table...

thanks in advance...
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now