January 7, 2016 at 3:59 pm
Hi,
When I am looking a sql job couple of jobs are executing SSIS package. Under history it is executing daily the same time. So I assumed that the job is scheduled on that time. But when I check under the schedules tab for that job, I didn't see any schedule timing but how can the job is executing daily without schedule. Is there any option in SSIS packages makes to run the job
January 7, 2016 at 10:56 pm
In msdb.dbo.sysjobactivity there is a run_requested_source column. That will tell you if a schedule or a user executed a job.
Values are documented here: https://msdn.microsoft.com/en-us/library/ms190484.aspx
If a user, check the job history for the user.
If it's the SSIS service account, then you'll need to go through each package and find the task that executes the job.
January 8, 2016 at 6:50 am
Andrew G (1/7/2016)
In msdb.dbo.sysjobactivity there is a run_requested_source column. That will tell you if a schedule or a user executed a job.Values are documented here: https://msdn.microsoft.com/en-us/library/ms190484.aspx
If a user, check the job history for the user.
If it's the SSIS service account, then you'll need to go through each package and find the task that executes the job.
In addition: it is also possible the job with the SSIS step is started by another job. It could also be started with code (using sp_startjob) from a stored procedure or from an application.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply