Best Companies Hiring Developers - Stack Overflow
The best companies turn to Stack Overflow to hire developers. Browse companies with job openings and learn more about the tech stack and employee benefits.
How to find all SQL Agent Jobs that call a given stored-proc
Here is a query that will give you that and more (look at the WHERE clause for the stored proc name):. SELECT [sJOB].[job_id] AS [JobID] , [sJOB].[name] AS [JobName ...
LSF - Get ID of submitted job - Stack Overflow
For the purposes of building dependencies, you can also name your job with -J then build the dependency based on the job name: bsub -J "job1" bsub -J "job2" bsub -w "done(job1) && done(job2)" There's a bit more info here. This also works with job arrays:
SQL Server Agent - get my own job_id - Stack Overflow
We had trouble with this recently and did not go the route you found in MSDN. Instead, we recovered the jobid from dbo.sysjobs by name directly (the opposite of your example) and then used that within the job to check execution status (exiting out of long running while loop if job state had changed).
Newest Questions - Stack Overflow
Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Try Teams for free Explore Teams
Using T-SQL to get the SSIS Package name, job name and description
[optional but nice to have] SSIS Job agent description. I'm able to pull all 3 of these pieces of information with no problems using the following tables: msdb.dbo.sysjobs gives me the Job name and Job description. msdb.dbo.sysssispackages gives me the SSIS Package name.
Get oozie job information in oozie workflow - Stack Overflow
By using the below command on command line, we get the job details of the oozie job even though it is still under progress.
sql - How can I determine the status of a job? - Stack Overflow
SELECT sj.name FROM msdb..sysjobactivity aj JOIN msdb..sysjobs sj on sj.job_id = aj.job_id WHERE aj.stop_execution_date IS NULL -- job hasn't stopped running AND aj.start_execution_date IS NOT NULL -- job is currently running AND sj.name = '' AND NOT EXISTS( -- make sure this is the most recent run select 1 from msdb ...
How do I raise an error that SQL will see as a job failure?
This all works fine - errors are raised and thrown up the stack, life is good. However, my RAISERROR calls don't appear to cause the job to fail - I'm set to receive an e-mail notification "When the job fails," but never receive one. E-mail notifications are working, as I will get emails if I change the notification to "when the job succeeds".
Obtain job id from a workflow run using contexts
I verified the non-uniqueness of runner IDs/names in practice by querying the GitHub REST API for a workflow run with 41 jobs - although all jobs had some runner_name, there were only 20 unique runner names in total, which matches the maximum number of concurrent jobs in the GitHub Free plan (this makes sense - more than 20 jobs are not allowed run concurrently, so it seems that when a runner ...
