Groups | Blog | Home
all groups > sql server dts > march 2006 >

sql server dts : Job Schedule does not stay enabled


JDP NO[at]SPAM Work
3/14/2006 9:35:42 AM
Every morning I must edit the "schedule" section of a certain job property,
click the [_]Enabled check box.

Do not confuse the issue, this is not the Enabled property for "the job", but
for the "Schedule" w/in the job.

The job runs fine all day executing once every 1 minute.

The only suspect is that in the "Manage" snapin I lost my SQL registration, and
found that I could temporarily restore it by re-registering the SQL server in
the EM.

I changed between using sa and Windows auth. w/similar results, Yeah it's back
in Manage, and sigh it's gone post reboot.

I really liked managing the SQL server from "Manage" but unless the two issues
are related, it would be a top priority to have this job's schedule stay
enabled.

TIA

JeffP...

Sue Hoegemeier
3/14/2006 10:05:12 PM
There were some issues in SQL 7 and 2000 with this - they
have been addressed in service packs so make sure you are up
to data on your service packs.

-Sue

On Tue, 14 Mar 2006 09:35:42 -0800, "JDP@Work"
[quoted text, click to view]
AddThis Social Bookmark Button