SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2008

ways to find the name of a running job

From time to time, I need to check (in my script) which jobs are running at the moment.So far, I have used the following three ways:

1. exec msdb..sp_help_job  @execution_status = 1

2. exec master..xp_sqlagent_enum_jobs 1, 'sa' -- checking the column [running], if it is 1, it means… Read more

1 comments, 1,760 reads

Posted in DBA Philosophy on 23 October 2008

Database Administration Librarian

If I cannot find a book or info in a library, I always go to a librarian for advice and I have never been disappointed. However, whenever I need to find a solution or information about a specific problem in database adminitratin domain, I always do a google search and… Read more

2 comments, 575 reads

Posted in DBA Philosophy on 7 October 2008