------------------------------------------------------------------------
-- MSSQL 예약작업 목록 출력
------------------------------------------------------------------------
-- 등록된 예약작업 목록을 출력
SELECT A.job_id, A.name, A.enabled,description, A.date_created, A.date_modified
, D.step_id, D.step_name, D.subsystem, D.command
FROM msdb.dbo.sysjobs A
INNER JOIN msdb.dbo.sysjobschedules B ON A.job_id = B.job_id
INNER JOIN msdb.dbo.sysschedules C ON B.schedule_id = C.schedule_id
INNER JOIN msdb.dbo.sysjobsteps D ON A.job_id = D.job_id
ORDER BY A.job_id, D.step_id
>> https://msdn.microsoft.com/ko-kr/library/ms175081(v=sql.110).aspx
SELECT *
FROM sys.sql_modules sm
inner join sys.all_objects ao
on sm.object_id = ao.object_id
order by modify_date desc
SELECT sm.object_id, OBJECT_NAME(sm.object_id) AS object_name, o.type, o.type_desc, sm.definition
FROM sys.sql_modules AS sm
JOIN sys.objects AS o ON sm.object_id = o.object_id
ORDER BY o.type;
------------------------------------------------------------------------
-- ORACLE 예약작업 목록 출력
------------------------------------------------------------------------
select interval, what
from user_jobs
where what like'%쿼리문%'
------------------------------------------------------------------------
-- ORACLE OBJECT(Function, Procedure, Package...)의 코드 확인
------------------------------------------------------------------------
SELECT TYPE, NAME -- , LINE
FROM user_source
WHERE upper(text) like '%'||upper('CUSTOMER')||'%'
GROUP BY TYPE, NAME
ORDER BY TYPE, NAME
------------------------------------------------------------------------
-- ORACLE TABLE명 확인
------------------------------------------------------------------------
SELECT * FROM TAB WHERE TNAME LIKE '%CUSTOMER%' -- 테이블 명
--ORDER BY TABTYPE, TNAME
;