sql server agent says that a job is running but the step says it has finished

Question

sql server agent says that a job is running but the step says it has finished

Igor Gelin 21

Hi,

We have a subscription for a SSRS report. The job in the agent says it is running.

Date 3/24/2022 5:30:00 PM
Log Job History (2669F99D-D502-40EC-8AF0-716394C50CBD)
Job Name 2669F99D-D502-40EC-8AF0-716394C50CBD
Duration 16:11:37.4270000
Message
In progress

But the step finished.

Date 3/24/2022 5:30:00 PM
Log Job History (2669F99D-D502-40EC-8AF0-716394C50CBD)
Step ID 1
Server MyCoolServer
Job Name 2669F99D-D502-40EC-8AF0-716394C50CBD
Step Name 2669F99D-D502-40EC-8AF0-716394C50CBD_step_1
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: NT AUTHORITY\SYSTEM. The step succeeded.

Why would the agent report the job as still running (for 16 hours) while the only step in the job finished in 1 second?

Thanks,
Igor

4 answers

Your answer

Answer 1

Naomi Nosonovsky 8,431

Hi Igor,

Did you find an answer to your question? I have a similar problem recently which I'm not sure how to figure out. I receive alerts that the job failed, however I see nothing exactly that indicates any failure and when I view the failed job history report we have on the production server I see: "The step did not generate any output. Process Exit Code 0. The step succeeded." The only explanation I may have that the custom report is somehow wrong or gather information wrongly?

Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator

2022-03-27T15:49:05.413+00:00

Not sure that your problem is the same as Igor's. When a job step fails, it is always a good idea to send output to a file. You do that on the Advanced tab of the job step.
Naomi Nosonovsky 8,431 Reputation points

2022-03-28T00:38:28.083+00:00

All our jobs have already been deployed without setting output file generation :( We don't have access to the production server SQL Agent, so we cannot view the actual history. My colleague somehow gathers information about all jobs and then produces a report. I think that report doesn't really help much to investigate. I guess I would need to adjust some of the jobs (at least) to produce output (going to do this now).

Answer 2

Isabellaz-1451 3,616

Hi anonymous userGelin-0063
SSRS doesn’t have its own built-in scheduling engine and instead uses SQL Agent. Whenever a subscription is created, a corresponding SQL Agent job is created that is scheduled to run according to the scheduling parameters for that subscription.

I think it make sense that the job duration is longer than the step duration，cause job is consist of many steps，and this step finished，maybe there are many other steps that you don't know. Or this is a long run job not once.

Best Regards,
Isabella

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Igor Gelin 21 Reputation points

2022-03-28T03:11:12.397+00:00

Hi Isabella,

I viewed the properties of the job. It has only one step, which ran in 1 second, because all my reports are optimized to achieve the best performance.

Thanks,
Igor
Isabellaz-1451 3,616 Reputation points

2022-03-28T08:47:33.293+00:00

then can you check the job schedule type，what is it？

Answer 3

Igor Gelin 21

It is "One Time".

Answer 4

Igor Gelin 21

Any help on this?

Share via

sql server agent says that a job is running but the step says it has finished

4 answers

Your answer