Subscribe to this blog
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, 492 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, 88 reads
Posted in DBA Philosophy on 7 October 2008