Viewing 4 posts - 1 through 4 (of 4 total)
You could also use the following I got from an earlier article on this site.
msdb.dbo.sp_get_composite_job_info NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL
Jeff
October 18, 2005 at 9:03 am
Looks like they were just added
July 1, 2004 at 7:58 am
Like Jordanac said above, it will fail on all databases with the SIMPLE recovery model, it will also fail if there has been an unlogged event in any database, ie...
June 14, 2004 at 10:29 am
It sounds like your IT Director or Auditors are mis-interpreting this. As for your question, it's a horrible idea. How do they expect a DBA to do the job if...
May 19, 2004 at 9:46 am
Viewing 4 posts - 1 through 4 (of 4 total)