Get the end time of the database after running JOB?

不悔不牛

I know that it is possible to build a log table after running the JOB in the database and get the end time.

But I am now a linked server.

Can anyone tell me how to get the time after the database runs?

There are best examples. Thank you

dream88

Write in JOB

fanfan1980

Check the system table sysjobservers

不悔不牛

I don't have permission to add to their JOB, and I can't see which JOB they have executed.

Can only be obtained on my machine to do other actions

不悔不牛

Under which database is the sysjobservers table? I did not find it.

fanfan1980

select * from msdb..sysjobservers

- Actually I don’t know, please check the online help yourself

不悔不牛

Thank you, I found it, the server with permission is OK, you can get it,
I don't have permission to query this table because my linked server
Is there any good way?

kittast

Let me send you an email when it's finished

不悔不牛

Fainted, I have not entered the mailbox, the JOB over there is estimated to start again.
And here it must be written as dynamic