Prev: AIML
Next: SQL logs
From: cj on 28 Jun 2010 15:27
I'm trying to figure out what some fired consultants did for us and of course
I can't ask them.

They have a process I run by executing the following sql command:

exec msdb.dbo.sp_start_job @job_name = 'B0C5788B-3F0C-4A94-81BC-12715D9891F6'

Where is this job 'B0C5788B-3F0C-4A94-81BC-12715D9891F6'? I'm trying to
find it. Where do I look for it?

The job was created as a data driven subscription by SQL Reports. I've been
tasked with making a similar process from another report. I took the report
I'm supposed to automate and created a data driven subscription from it but I
don't know where it put it and I don't know what name is was given. If I can
find the job above I will know where mine is and what it is named--hopefully.

Just FYI a VB program runs the sql command during the night as part of
processing stuff so it's not like I go into sql and actually execute that
command--though I could.

From: Eric Isaacs on 28 Jun 2010 16:21
Which version of SQL Server are you using?

Look for the job under the server name...Management...SQL Server
Agent...Jobs.

You should be able to schedule the job without needing a VB program.

-Eric Isaacs
J Street Technology, Inc.
425-869-0797
From: Bob Barrows on 28 Jun 2010 16:25
cj wrote:
> I'm trying to figure out what some fired consultants did for us and
> of course I can't ask them.
>
> They have a process I run by executing the following sql command:
>
> exec msdb.dbo.sp_start_job @job_name =
> 'B0C5788B-3F0C-4A94-81BC-12715D9891F6'
>
> Where is this job 'B0C5788B-3F0C-4A94-81BC-12715D9891F6'? I'm trying
> to find it. Where do I look for it?
>

What version of SQL Server are you using?

SQL 2000: Enterprise Manager
Servername>Management>SQL Server Agent>Jobs

SQL 2005: SSMS:
Servername>Sql Server Agent>Jobs

If you've looked there and failed to see it, then perhaps the job is
created dynamically and subsequently deleted.



--
HTH,
Bob Barrows


From: cj on 29 Jun 2010 10:08

Thanks, it is there. I know it can be scheduled w/o VB but I need the VB
program to get things ready for the job to run.
 | 
Pages: 1
Prev: AIML
Next: SQL logs