On Feb 20, 10:34 pm, "jobs" <j...@webdos.com> wrote:
> Is it possible for an SP to check to see if it's running as job, and
> if so, get it's own jobname and jobid?
>
> Also curious, does any know, is it possible to use ssis variables to
> set the connection, operation and file type settings in an ssis ftp
> task or must those items be preset?

>
> You can query on sysjobsteps on MSDB and look for SP name in command
> field
>

On Feb 20, 10:52 pm, "jobs" <j...@webdos.com> wrote:
> > You can query on sysjobsteps on MSDB and look for SP name in command
> > field
>
> I was hoping there would be something more concrete. I'm creating the
> jobs on the fly and inserting the sp on the fly into it as well. There
> will be the chance that two jobs could be running the same sp at the
> same time.
>
> No way to get current session information and connect the dots that
> way?
>
> thank you!

> If you are creating the job on the fly, you should have the job name
> within the scope already. Probably I am not understanding your
> requirement clearly.

>
> Very true. I'm trying to pass parameters to an SSIS FTP task and
> launch it asynchronously as a job. I thought launching the package
f> from sp would make sense - it actually does not. I guess I need to
> understand how parameters are passed to SSIS packages in a job.