June 15, 2004 at 12:38 am
Is there any way or histroy from where to find when an SQL Agent Job is disabled and associated login which disabled that job ? Sever doesnot have C2 -audit enable.
--Snt
June 15, 2004 at 4:45 am
Try SP_HELP_JOB @job_name = 'JOBNAME'. This will give you some of the info that you wan't but as to who modified the job I dont think that you can get it.
Andy.
June 15, 2004 at 6:15 am
This is a quick query to check for disabled job, but it won't show who did the disabling.
SELECT name
FROM msdb.dbo.sysjobs
WHERE enabled = 0
ORDER BY name
June 16, 2004 at 7:19 am
When I try EXEC sp_help_job in Query Analyzer I get the following message:
Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_help_job'.
I am running MSSQL 2000 on Windows NT 4.0sp6a.
I looked it up in BOL and the spelling appears to be correct.
Does anyone have any idea as to why this does not work for me?
Howard
June 16, 2004 at 8:26 am
I think you may have to use the "MSDB" DB or include "USE MSDB" prior to the store proc, like this...
USE MSDB
EXEC SP_HELP_JOB @job_name = 'JOBNAME'
June 16, 2004 at 8:44 am
Make sure you're in the msdb database.
June 16, 2004 at 8:48 am
That did it (Make sure you're in the msdb database.)
Thanks,
Howard
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply