Is there a technique for determining when a job has been executed - using T-SQL? I tried using 'sp_help_job' by inserting the output into a table (e.g. INSERT jobtable EXEC sp_help_job...) but I get the following error:
Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 68
An INSERT EXEC statement cannot be nested.
Any ideas anyone?
Rgds
Bertrand
You can all the info from msdb..sysjobs and msdb..sysjobsteps table. I suggest you take a look at the following article (thanks Gert) so you can handle the sqlagent datetime.http://sqldev.net/sqlagent/SQLAgentDateTime.htm
No comments:
Post a Comment