| |

VerySource

 Forgot password?
 Register
Search
View: 769|Reply: 8

Get the end time of the database after running JOB?

[Copy link]

1

Threads

8

Posts

9.00

Credits

Newbie

Rank: 1

Credits
9.00

 China

Post time: 2020-3-16 10:00:02
| Show all posts |Read mode
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
Reply

Use magic Report

0

Threads

28

Posts

25.00

Credits

Newbie

Rank: 1

Credits
25.00

 China

Post time: 2020-6-16 21:00:01
| Show all posts
Write in JOB
Reply

Use magic Report

0

Threads

211

Posts

108.00

Credits

Newbie

Rank: 1

Credits
108.00

 China

Post time: 2020-6-17 18:15:01
| Show all posts
Check the system table sysjobservers
Reply

Use magic Report

1

Threads

8

Posts

9.00

Credits

Newbie

Rank: 1

Credits
9.00

 China

 Author| Post time: 2020-6-18 14:00:01
| Show all posts
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
Reply

Use magic Report

1

Threads

8

Posts

9.00

Credits

Newbie

Rank: 1

Credits
9.00

 China

 Author| Post time: 2020-6-19 22:30:01
| Show all posts
Under which database is the sysjobservers table? I did not find it.
Reply

Use magic Report

0

Threads

211

Posts

108.00

Credits

Newbie

Rank: 1

Credits
108.00

 Australia

Post time: 2020-6-20 14:30:01
| Show all posts
select * from msdb..sysjobservers

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

Use magic Report

1

Threads

8

Posts

9.00

Credits

Newbie

Rank: 1

Credits
9.00

 China

 Author| Post time: 2020-6-21 18:30:01
| Show all posts
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?
Reply

Use magic Report

2

Threads

18

Posts

16.00

Credits

Newbie

Rank: 1

Credits
16.00

 China

Post time: 2020-6-22 20:45:01
| Show all posts
Let me send you an email when it's finished
Reply

Use magic Report

1

Threads

8

Posts

9.00

Credits

Newbie

Rank: 1

Credits
9.00

 China

 Author| Post time: 2020-6-23 09:45:01
| Show all posts
Fainted, I have not entered the mailbox, the JOB over there is estimated to start again.
And here it must be written as dynamic
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list